Data Warehouse Interview Questions
Questions Answers Views Company eMail

list out all the transformations which use cache?

Informatica,

769

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,

789

What are multi-group transformations?

Informatica,

646

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

Informatica,

975

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

Informatica,

700

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

Informatica,

735

How can we improve session performance in aggregator transformation?

Informatica,

758

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

Informatica,

949

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

Informatica,

695

What is Data Caches size?

Informatica,

736

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

Informatica,

766

Explain load alternative records / rows into multiple targets - informatica

Informatica,

802

Explain lookup transformation in informatica

Informatica,

736

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

Informatica,

663

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

Informatica,

723


Un-Answered Questions { Data Warehouse }

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

1998


What is conformed fact?

725


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

705


What needs to be done when the database is shutdown?

636


Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com

1710






Explain how to get the first 100 rows from the flat file into the target?

597


What is smp and mpp platforms?

609


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1231


Define dimensions?

706


Explain what is the use of proc gplot?

812


Can Bo generates the Report from the cubical data Explain?

1704


give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

2001


Have you worked with packages?

776


How to connect a private redshift cluster?

1


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

643