1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

list out all the transformations which use cache?

Informatica,

836

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

Informatica,

853

What are multi-group transformations?

Informatica,

718

Design a mapping to load a target table with the following values from the above source?

Informatica,

1043

How to load last n records of file into target table - informatica

Informatica,

779

What is the commit type if you have a transaction control transformation in the mapping?

Informatica,

788

How can we improve session performance in aggregator transformation?

Informatica,

827

Explain direct and indirect flat file loading (source file type) - informatica

Informatica,

1021

What are the basic requirements to join two sources in a source qualifier transformation using default join?

Informatica,

755

What is Data Caches size?

Informatica,

793

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

Informatica,

842

Explain load alternative records / rows into multiple targets - informatica

Informatica,

857

Explain lookup transformation in informatica

Informatica,

787

How many ways a relational source definition can be updated and what are they?

Informatica,

743

What are the differences between joiner transformation and source qualifier transformation?

Informatica,

812

Un-Answered Questions { Data Warehouse }

Explain the teradata primary index mechanics in detail with a diagram.

697

Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?

683

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

769

Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!

1737

What is a macro routine?

2278




What are the various etl tools in the market?

758

Explain etl?

696

How to execute the plsql procedure from the report by clicking with mouse?

764

Tell us about the architecture of abinitio.

801

Have you created hierarchy in obiee. If so where and how?

603

What is dimensional modeling?

736

Differentiate between Load Manager and DTM?

1829

Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?

849

Explain why denormalization is promoted in universe designing?

666

Can we start and stop single session in concurent bstch?

658

For More Un-Answered { Data Warehouse } Questions Click Here