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 15766

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 17652

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

IBM,

11 19462

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

InfoCepts, TCS,

1 8327

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

Wipro,

1 5030

Difference between session variables and workflow variables?

Informatica,

2 20740

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

2 13411

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

TCS,

5 8276

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

2799

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 8260

how many data models u have done in informatica project?

TCS,

2 8394

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 11628

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 11124

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 7543

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

Ness Technologies,

2 7580

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the different types of olap? Give an example?

1099

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1116

What are the different options available for update strategy?

1055

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2445

What is Cognos script editor?

4293

What is intricate mapping?

1322

What are the prerequisite tasks to achieve the session partition?

1300

What is the session task and command task?

1117

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1123

What are mapplets? How is it different from a Reusable Transformation?

1140

What does reusable transformation mean?

1199

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1214

server hot-ws270 is connect to Repository B. What does it mean?

2658

State the limitations where we cannot use joiner in the mapping pipeline?

1109

What is sequence generator transformation in informatica?

1127

For More Un-Answered { Informatica } Questions Click Here