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 11272

diffrence between command task and control task

iNautix,

1 7229

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 6981

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

1981

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 7114

how can import the data from the flat files?

2 5845

major difference between normal loading and bulk loading?

6 12191

explain about session partitions ?

1 5733

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 8457

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

2002

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

Cegedim,

3 7690

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

3 6436

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 6573

what is song in infrmatica...?

CTS,

2184

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 10222

Post New Informatica Questions

Un-Answered Questions { Informatica }

When do you use sql override in a lookup transformation?

1043

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1086

Can we create a Integration service without a Repository service and vice versa?

1187

What are the prerequisite tasks to achieve the session partition?

1203

What is decode in static cache?

1111

What are the tasks that can be performed using sq?

1043

Design a mapping to load a target table with the following values from the above source?

1307

What is a stored procedure transformation?

1009

What is the way to execute pl/sql script using informatica mapping?

1537

Differences between connected and unconnected lookup?

1159

 Informatica Checkpoints

3279

What is the sequence generator transformation in informatica?

1122

How can you differentiate between powercenter and power map?

1035

Design time, run time. If you don't create parameter what will happen

1814

What is the use of source qualifier?

1088

For More Un-Answered { Informatica } Questions Click Here