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 11415

diffrence between command task and control task

iNautix,

1 7300

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 7081

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

2029

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 7240

how can import the data from the flat files?

2 5934

major difference between normal loading and bulk loading?

6 12388

explain about session partitions ?

1 5818

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 8643

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

2049

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

Cegedim,

3 7833

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

3 6550

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 6666

what is song in infrmatica...?

CTS,

2235

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 10341

Post New Informatica Questions

Un-Answered Questions { Informatica }

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

1053

What is standalone command task?

1315

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2064

How do you migrate data from one environment to another?

1095

What all are steps in up gradation of Informatica server?

1045

How many transformations can be used in mapplets.

1935

What is update strategy transform?

1101

What is the Rank index port in Rank transformation?

1059

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2261

Define sessions in informatica etl?

1034

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

4109

What is a code page?

1177

Where is metadata stored?

1111

Differences between version 7.x and 8.x.

1893

What are the data movement modes in informatica?

1152

For More Un-Answered { Informatica } Questions Click Here