Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

what is mapping performence?

Cap Gemini,

2 6582

what is the incremental agrrigation?

Cap Gemini,

2 7244

what is shared lookup&persistent lookup?

Accenture, Cap Gemini,

4 11070

following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

Patni,

2 6000

how many session run unix environment what command using ?

HCL,

1 7222

follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000

IBM,

5 9677

following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

Wipro,

5 9099

What is degenerated dimention table?

Patni,

7 10558

what are the unix commands to start the wrk flow ?

Accenture, TCS,

4 12524

What is junk dimention?

Patni,

3 8041

I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

Patni,

4 9096

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

IBM,

4727

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

IBM,

2 7199

without dynamic lookup transformation how to insert new rows and update existing rows?

Cap Gemini,

7 16630

one source to target loading insert new rows and update existing rows?

Polaris,

3 7375

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the advantage of informatica?

1069

State the limitations where we cannot use joiner in the mapping pipeline?

1067

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1628

Whats there in global repository

1692

How can we improve session performance in aggregator transformation?

1117

Which transformation is needed while using the Cobol sources as source definitions?

1174

What is the difference between a connected look up and unconnected lookup?

966

What is a passive transformation?

1104

Write the unconnected lookup syntax?

1084

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1267

What are the new features of informatica 9.x developer?

970

Is it possible to use a client with different version than that of its Informatica server?

1141

While migrating the data from one environment to another environment how would you manage the connections?

1090

What are the advantages of informatica?

1014

Briefly define reusable transformation?

1128

For More Un-Answered { Informatica } Questions Click Here