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 11416

diffrence between command task and control task

iNautix,

1 7302

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 7083

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 7242

how can import the data from the flat files?

2 5936

major difference between normal loading and bulk loading?

6 12390

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 8646

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 7835

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

3 6552

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 6667

what is song in infrmatica...?

CTS,

2237

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 10344

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is a sequence generator transformation?

1021

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

1122

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1866

Which means the first record should come as last record and last record should come as first record and load into the target file?

1080

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1075

What is source qualifier transformation in informatica?

1011

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2184

While migrating the data from one environment to another environment how would you manage the connections?

1090

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

2066

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1109

What is the function of union transformation?

1134

What is the Process to creating lookup transformation in informatica

1044

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

2048

What is the cumulative sum and moving sum?

1186

complex mapping ur project u r invlve can u explain and give real time example give me ?

2298

For More Un-Answered { Informatica } Questions Click Here