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

Informatica Interview Questions

Questions Answers Views Company eMail

If I have a index defined on target table and if set it to bulk load will it work ?

IBM,

4 15591

When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

IBM,

3 17521

Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

IBM,

11 19018

how can we check whether a particular cache is static or dynamic?

InfoCepts, TCS,

1 8238

Can any one explain or sujjest some sites for scd mappings.Thank you

Wipro,

1 4949

Difference between session variables and workflow variables?

Informatica,

2 20608

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 13267

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

TCS,

5 8096

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 are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance

3 8080

how many data models u have done in informatica project?

TCS,

2 8276

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 11441

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

TCS,

6 10899

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

Ness Technologies,

2 7415

How can we get two output ports in un-connect transformation?

Ness Technologies,

2 7469

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain pushdown optimization $pushdownconfig parameter - informatica

1137

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

986

What is a pre-defined event and user-defined event?

1037

What are the types of schemas we have in data warehouse.

961

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

1129

What are the databases that informatica can connect to windows?

1049

How union transformation is used?

1005

what is informatica metadata?

1036

What is the difference between informatics 7x and 8x and what is latest version?

1085

Explain the informatica workflow?

1067

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

1181

What is the function of aggregator transformation?

1084

What is data caches/ index caches?

1103

Can we get 1st record through Informatica(without sequence number).

1479

How you know when to use a static cache and dynamic cache in lookup transformation?

1854

For More Un-Answered { Informatica } Questions Click Here