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

Informatica Interview Questions

Questions Answers Views Company eMail

If we are using an aggregator but forget to mention the group by port .what will be the output??

Nomura, TCS,

11 34161

I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 10768

can we create index and drop index in exsisting table while using infomatica

4 20003

"Change cache" in Informatica ?

2 7625

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 15935

What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 19294

how we do performence tuning in informatica

3 7933

Diff b/w ShortCut and reusabel Object ?

4 8417

What are the ETL tools available in DWH?

Mphasis,

6 15280

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

iGate,

5 11911

Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

iGate,

1 6925

I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 8150

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

TCS,

3 10557

Router T/R is active but some people are saying it is also passive which is exactly right?

5 20409

how to convert the .doc docs into .txt format using informatica

4 12455

Post New Informatica Questions

Un-Answered Questions { Informatica }

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1951

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1993

How might you approve all mappings in the archive all the while?

1016

Enterprise data warehouse your projects phase by phase explain?

1917

Explain sql transformation in script mode examples in informatica

1130

What is a stored procedure transformation?

1049

What is informatica worklet?

1059

What is meant by target load plan?

970

What are the differences between oltp and olap?

969

what are 3 tech challenges/ common issues you face?

2342

How to go to the older version for a mapping?

1094

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1010

What is mapplet in informatica?

1053

What is informatica? Why do we need it?

1092

Where is metadata stored?

1106

For More Un-Answered { Informatica } Questions Click Here