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 6701

what is the incremental agrrigation?

Cap Gemini,

2 7350

what is shared lookup&persistent lookup?

Accenture, Cap Gemini,

4 11196

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 6098

how many session run unix environment what command using ?

HCL,

1 7342

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 9862

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 9287

What is degenerated dimention table?

Patni,

7 10822

what are the unix commands to start the wrk flow ?

Accenture, TCS,

4 12697

What is junk dimention?

Patni,

3 8219

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 9282

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,

4783

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 7345

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

Cap Gemini,

7 16870

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

Polaris,

3 7543

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are different types of transformations available in informatica?

1061

What is persistent lookup cache?

1100

What is option by which we can run all the sessions in a batch simultaneously?

1196

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2410

How union transformation is used?

1057

How identifying bottlenecks in various components of informatica and resolving them?

1182

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5798

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2604

COM components can be used in Informatica

2456

What are the various types of transformation?

1246

How do you load only null records into target? Explain through mapping flow.

2077

What is the maplet?

1206

How can we use mapping variables in informatica? Where do we use them?

1294

my source is junk data how will u remove that junk data by using unix please any one replay me

3755

What is union transformation in informatica?

1193

For More Un-Answered { Informatica } Questions Click Here