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 11394

diffrence between command task and control task

iNautix,

1 7292

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 7072

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

2025

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 7227

how can import the data from the flat files?

2 5921

major difference between normal loading and bulk loading?

6 12375

explain about session partitions ?

1 5809

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 8627

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

2045

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

Cegedim,

3 7811

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

3 6545

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 6658

what is song in infrmatica...?

CTS,

2230

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 10326

Post New Informatica Questions

Un-Answered Questions { Informatica }

Differentiate between router and filter transformation?

1007

How can we delete duplicate rows from flat files?

1218

How can we update a record in the target table without using update strategy?

1136

How to load a Dimension ? and how to load a fact table?

1408

difference between informatica 8.1.1 and 8.6

3673

Define Pmrep command?

1048

Whats there in global repository

1689

Name the different lookup cache(s)?

1227

Tell me about Propagate functions in informatica

917

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

1597

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1698

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1773

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2718

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1077

How would you join a node to the already existing domain?

1123

For More Un-Answered { Informatica } Questions Click Here