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 15398

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 17392

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

IBM,

11 18694

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

InfoCepts, TCS,

1 8155

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

Wipro,

1 4892

Difference between session variables and workflow variables?

Informatica,

2 20494

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

2 13139

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

TCS,

5 7920

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

2699

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 7921

how many data models u have done in informatica project?

TCS,

2 8158

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 11236

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 10688

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 7309

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

Ness Technologies,

2 7361

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to elaborate tracing level?

1131

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1750

What is the use of transformation?

963

How to do unit testing in informatica? How to load data in informatica ?

1060

Enlist the differences between database and data warehouse.

1065

How do you handle two sessions in Informatica

1091

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4086

What is DR strategy for Informatica project?

1128

Implementation methodology

1663

How to Create a folder using pmrep command?

1124

What are the types of caches in lookup?

993

Explain why we use partitioning the session in informatica?

1029

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1069

What is dimensional table?

1018

What are the different clients of powercenter?

1021

For More Un-Answered { Informatica } Questions Click Here