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 6571

what is the incremental agrrigation?

Cap Gemini,

2 7234

what is shared lookup&persistent lookup?

Accenture, Cap Gemini,

4 11044

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 5988

how many session run unix environment what command using ?

HCL,

1 7211

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 9664

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 9082

What is degenerated dimention table?

Patni,

7 10530

what are the unix commands to start the wrk flow ?

Accenture, TCS,

4 12487

What is junk dimention?

Patni,

3 8025

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 9082

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,

4725

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 7191

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

Cap Gemini,

7 16593

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

Polaris,

3 7359

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is a filter transformation and why it is an active one?

968

What is update strategy transform?

1096

What is blocking transformation?

1139

What is the Process to creating lookup transformation in informatica

1040

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

1038

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1971

What are the modules in Power Center

1675

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2302

Where do we use mapping variables in informatica?

1061

What is flashback table ? Advance thanks

1930

What is event and what are the tasks related to it?

1119

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2195

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1668

what is index?how it can work in informatica

2038

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1919

For More Un-Answered { Informatica } Questions Click Here