O9XNZMXB access denied for user to path

O9XNZMXB access denied for user to path

Add or Update the below tags in instanceconfig.xml
<Catalog>

<UpgradeAndExit>false</UpgradeAndExit>

<Validate>OnStartup</Validate>

<ValidateItems>None</ValidateItems>

<ValidateLinks>None</ValidateLinks>

<ValidateAccounts>Clean</ValidateAccounts>

<ValidateHomes>None</ValidateHomes>

<UpdateAccountGUIDs>UpdateAndExit</UpdateAccountGUIDs>

</Catalog>

 Add the below in NQSConfig

FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;

After updating the tags restart the opmn services.

Informatica Interview Questions

1. If my source table has 20 records with all "sal" column values greater than 100. if I have given this data  as an input to router with three conditions 

§ Sal > 10

§ Sal > 20

§ Sal > 100

Then , for which group the data will move?

2. Dynamic lookup cache vs static cache vs persistent cache

3. Unconnected vs connected lookups

4. If my aggregator has three columns empno, name ,sal and empno column contains duplicates e.g.:

Empno	Name	Sal
1	X	100
1	Y	50
1	Z	30
2	x	50
2	y	400
2	z	30

1	Y	50
1	Z	30
2	x	50
2	y	400
2	z	30

If I have given a group by on empno column and calculating sum(sal) then what will be the output at the target if the target contains three columns.

5. What happens if my source qualifier SQL override query column sequence is different from columns defined in Source Qualifier?

Ans: it won't accept, the sequence of columns in source qualifier should match with sequence of columns in sql override query.

6.What happens if my lookup SQL override query column sequence is different from columns defined in lookup Transformation

Ans: it will accept, if  the sequence of columns in lookup Transformation should not match with sequence of columns in sql override query

7.Write a query for finding the duplicate values in the database without using distinct command.

8.Write a query to find the 5th highest salary in the database.

OBIEE Interview Questions

--> How to add distinct in report?

--> Log not found, even after setting the log level to more than 2?

--> Reason for Unresolved column , In Rpd column is available with correct names and able to view data in Physical Layer

--> Opaque views usage?

--> Aggregate navigation not working, logical level setting is correct?

--> Rpd 2-way merging vs 3-way

--> Dimensional hierachy vs Parent Child

--> What Metadata tables of the Delivers/Agents

--> Archeitecture of OBIEE 11g

--> Start Schema,Snow flake schema

--> Complex jOin and physical join

--> Presentation varaibles usage