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 7245

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 6001

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 9678

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 9100

What is degenerated dimention table?

Patni,

7 10558

what are the unix commands to start the wrk flow ?

Accenture, TCS,

4 12526

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 are the different options available for update strategy?

1003

How can you define user defied event?

1031

How to generate sequence numbers using expression transformation?

1089

Design time, run time. If you don't create parameter what will happen

1837

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1167

What does update strategy mean, and what are the different option of it?

1091

What is the benefit of partitioning a session?

1182

Differentiate between sessions and batches?

1018

How to implement security measures using repository manager?

1178

How would you join a node to the already existing domain?

1130

Design a mapping to load a target table with the following values from the above source?

1346

What is meant by target load plan?

974

Why sorter is an active transformation?

1192

What the difference is between a database, a data warehouse and a data mart?

1155

What are the components of Informatica? And what is the purpose of each?

1055

For More Un-Answered { Informatica } Questions Click Here