Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

What is the Hierarchy of DWH?

1 6861

How many repositories can we create in Informatica?

3 7044

What is surrogate key?

9 22555

What is difference between Mapplet and reusable transformation?

Wipro,

9 40376

What is aggregate awareness?

1 8562

Explain reference cursor?

1 8331

What are parallel querys and query hints?

1 7044

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

1 4897

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

1 4734

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

4 8878

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

1 3404

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

2 4079

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

2 7257

what is a transforamation?

5 5620

What are the designer tools for creating tranformations?

Informatica,

1 4866


Post New Informatica Questions

Un-Answered Questions { Informatica }

How can we improve session performance in aggregator transformation?

514


Explain your project of banking domian.

1041


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

472


Explain in detail about scd type 1 through mapping.

412


How do you promote a non-reusable transformation to reusable transformation?

503






What is rank transform?

431


Global and Local shortcuts. Advantages.

1279


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

515


What is target designer and target load order?

512


how to load rows into fact table in data warehouse

491


What is meant by lookup transformation?

439


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1485


Mention few advantages of router transformation over filter transformation.

447


What is a dimensional model?

424


What do you mean by channel change?

399