How do you load more than 1 max sal in each department through informatica or write sql query in oracle?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,


write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

3 Answers   Cognizant, Flextronics,


Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,


My source table having some records ,i want load 1st record and last record into one target?

3 Answers   iGate,


In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?

4 Answers  


Different sorts of metadata that stores in the storage facility?

1 Answers  


What is the role of informatica in project ?Like i showed financial projects?

1 Answers   Amdocs,


i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,


What is the difference between Active and Passive transformation?

1 Answers   Informatica,


what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,


How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

2 Answers   IBM,


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1 Answers   Patni,


Categories