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.