Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

in realtime which situations u can use unconnected lookup transformation

Patni,

2 8273

in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

Patni,

3 9894

i have source in oracle 10g,oracle 8i how will u take the data from two sources

TCS,

2 5033

why we are using surogate key in real time give me explanation

TCS,

2 7103

How informatica process data means how informatica works?

TCS,

2 13158

Can we run session without using workflows?

TCS,

5 22296

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

HCL, HP,

2 7823

what is the location of parameter file in informatica?

TCS,

1 8461

what is runtime variable?

TCS,

3 7390

which is better perfomancewise lookup or joiner and why?can anyone give example?

TCS,

6 12061

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

TCS,

2859

How to delete first 3 rows & last 3 rows in target table in informatica

TetraSoft,

6 14785

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

KPIT,

1 9743

write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

Cognizant, Flextronics,

3 7867

what is the size ur source like(file system or database)? how many record daily come u r banking project?

Cognizant, Flextronics,

2146

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain the scenario which compels informatica server to reject files?

1166

Explain the tuning lookup transformation - informatica

992

What is a mapplet/worklet in informatica?

1185

what is the complex transformation you used in informatica

2587

How to improve the performance of a session using sorter transformation?

1144

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4109

Different qualification between a related rotate toward the sky and isolates look upward?

986

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2744

What is the difference between router and filter?

1267

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1032

Explain informatica architecture - version 8 / 9

1087

What is workflow? What are the components of the workflow manager?

1136

What is rank transform?

994

What are the types of presistent cache in look up tr.

2055

without table how to come first record only in oracle?

2251

For More Un-Answered { Informatica } Questions Click Here