Informatica Interview Questions
Questions Answers Views Company eMail

what is mapping performence?

Cap Gemini,

2 5622

what is the incremental agrrigation?

Cap Gemini,

2 6090

what is shared lookup&persistent lookup?

Accenture, Cap Gemini,

4 9575

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 5015

how many session run unix environment what command using ?

HCL,

1 5913

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 8205

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 7350

What is degenerated dimention table?

Patni,

7 8341

what are the unix commands to start the wrk flow ?

Accenture, TCS,

4 10833

What is junk dimention?

Patni,

3 6679

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 7774

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,

4301

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 6115

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

Cap Gemini,

7 14274

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

Polaris,

3 6006


Post New Informatica Questions

Un-Answered Questions { Informatica }

When do you use sql override in a lookup transformation?

575


What is sequence generator transformation in informatica?

610


In how many ways we can create ports?

693


What do you mean by worklet?

618


What is repository manager?

526






How can you define user defied event?

608


Explain the different lookup methods used in informatica?

574


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

614


Which development components of informatica have the highest usage?

582


What are the performance considerations when working with aggregator transformation?

667


What is a rank transform?

664


Mention few power centre client applications with their basic purpose?

525


What is rank transformation in informatica

680


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

1765


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1577