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 6467

what is the incremental agrrigation?

Cap Gemini,

2 7122

what is shared lookup&persistent lookup?

Accenture, Cap Gemini,

4 10880

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 5889

how many session run unix environment what command using ?

HCL,

1 7078

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 9502

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 8875

What is degenerated dimention table?

Patni,

7 10223

what are the unix commands to start the wrk flow ?

Accenture, TCS,

4 12267

What is junk dimention?

Patni,

3 7854

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 8901

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,

4678

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 7077

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

Cap Gemini,

7 16262

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

Polaris,

3 7168

Post New Informatica Questions

Un-Answered Questions { Informatica }

During the running session, output files are created by informatica server. Enlist few of them.

935

Explain what transformation and how many are there in informatica?

891

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7074

Define enterprise data warehousing?

1131

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1987

How can you generate reports in informatica?

974

Write the program through which the records can be updated?

938

Explain dynamic target flat file name generation in informatica

1011

What are pre and post-session shell commands?

1239

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

1083

How do you migrate data from one environment to another?

1046

how to load rows into fact table in data warehouse

1118

What is the function of union transformation?

1067

How to extract sap data using informatica? What is abap? What are idocs?

1092

How to open an older version of an object in the workspace?

1131

For More Un-Answered { Informatica } Questions Click Here