Informatica Interview Questions
Questions Answers Views Company eMail

What are ETL Tools?

Informatica,

671

What are the types of data warehouses?

Informatica,

948

How to partition the Session?

Informatica,

648

How to create Target definition for flat files?

Informatica,

756

How do you handle two sessions in Informatica

Informatica,

669

What are the guidelines to be followed while using union transformation?

Informatica,

643

Which transformation should we use to normalise the COBOL and relational sources?

Informatica,

748

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

Informatica,

629

What is aggregate cache in aggregator transformation?

Informatica,

637

What is the sql query overwrite in source qualifier in informatica

Informatica,

621

Why union transformation is an active transformation?

Informatica,

659

What are the limitations of joiner transformation?

Informatica,

657

Explain joiner transformation in informatica

Informatica,

672

What are the informatica performance improvement tips

Informatica,

619

What are the mapping parameters and mapping variables?

Informatica,

626


Post New Informatica Questions

Un-Answered Questions { Informatica }

What does cheating measurement mean?

602


Explain the etl program with few examples.

548


What is the difference between router and filter?

651


Differentiate between source qualifier and filter transformation?

1003


What is the difference between source qualifier transformations source filter to filter transformation?

589






What are the differences between oltp and olap?

553


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

4990


Different sorts of metadata that stores in the storage facility?

564


What is complex mapping?

641


What is the need for an etl tool?

640


While importing the relational source definition from the database, what are the metadata of source that will be imported?

797


Mention few advantages of router transformation over filter transformation.

642


What are the guidelines to be followed while using union transformation?

643


Can u generate reports in Informatica?

661


Explain sessions?

606