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

Informatica Interview Questions

Questions Answers Views Company eMail

i have two source data there is no pk,fk how to join the two sources

TetraSoft,

5 11620

diffrence between command task and control task

iNautix,

1 7393

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

Wipro,

3 7220

is it possible to index the data in cache of lkp transformation ?

2080

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 7370

how can import the data from the flat files?

2 6049

major difference between normal loading and bulk loading?

6 12594

explain about session partitions ?

1 5944

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

TCS,

5 8800

if we have a delimiters at unwanted places in a flat file how can we over come those.

2090

what is the hint? how to use it to reduce the query processing in program?

Cegedim,

3 7985

Can I create one wrkflw which will run different wrkflws on schedule time?

3 6661

a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

TCS,

2 6782

what is song in infrmatica...?

CTS,

2327

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

TCS,

3 10469

Post New Informatica Questions

Un-Answered Questions { Informatica }

What happens when a session fails and you click on recover?

1178

What does “tail –f” command do and what is its use as an Informatica admin.

1147

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2109

tell me 5 session failure in real time how can you solve that in your project?

2396

What is a passive transformation?

1154

What are the tuning techniques you applied during your last project

2078

difference between repository database and repository service?

1225

What are the popular informatica products?

1059

How would you copy the content of one repository to another repository?

1061

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

1116

Is it possible to use a client with different version than that of its Informatica server?

1193

Explain the tuning lookup transformation - informatica

1048

Could you explain what is enterprise data warehouse?

1229

What all join we can perform in LOOKUP transformation?

1024

Explain sessions?

1141

For More Un-Answered { Informatica } Questions Click Here