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

Informatica Interview Questions

Questions Answers Views Company eMail

What is the Hierarchy of DWH?

1 7822

How many repositories can we create in Informatica?

3 8693

What is surrogate key?

9 26752

What is difference between Mapplet and reusable transformation?

Wipro,

9 44363

What is aggregate awareness?

1 9502

Explain reference cursor?

1 9577

What are parallel querys and query hints?

1 8100

While importing the relational source defintion from database,what are the meta data of source U import?

1 6281

Howmany ways yoU can update a relational source defintion and what are they?

1 5801

Where should yoU place the flat file to import the flat file defintion to the designer?

4 11086

To provide support for Mainframes source data,which files r used as a COBOL files

1 4340

Which transformation should u need while using the cobol sources as source defintions?

2 5522

How can yoU create or import flat file definition in to the warehouse designer?

2 8590

what is a transforamation?

5 8149

What are the designer tools for creating tranformations?

Informatica,

1 6159

Post New Informatica Questions

Un-Answered Questions { Informatica }

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1328

Can you generate sequence numbers without using the sequence generator transformation?

1124

write a query to retrieve the latest records from the table sorted by version(scd)

1074

Explain in detail scd type 2 through mapping.

1050

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2163

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

1132

Reusable transformation and shortcut differences

1844

What is the need of an ETL tool?

1108

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1641

COM components can be used in Informatica

2397

Can we create two repositories on same database instance in oracle?

1103

When do you use sql override in a lookup transformation?

1101

How are indexes created after completing the load process?

1655

What is the sql query overwrite in source qualifier in informatica

1097

Does an informatica transformation support only aggregate expressions?

1049

For More Un-Answered { Informatica } Questions Click Here