Data Warehouse Interview Questions
Questions Answers Views Company eMail

Explain about cumulative Sum or moving sum?

Informatica,

701

Explain lookup transformation source types in informatica

Informatica,

785

What is a transaction control transformation?

Informatica,

854

Define mapping and session?

Informatica,

675

Design a mapping to load the cumulative sum of salaries of employees into target table?

Informatica,

1025

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

Informatica,

716

What are ETL Tools?

Informatica,

747

What are the types of data warehouses?

Informatica,

1033

How to partition the Session?

Informatica,

729

How to create Target definition for flat files?

Informatica,

867

How do you handle two sessions in Informatica

Informatica,

767

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

Informatica,

741

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

Informatica,

829

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

Informatica,

708

What is aggregate cache in aggregator transformation?

Informatica,

712


Un-Answered Questions { Data Warehouse }

Explain what are slowly changing dimensions?

700


Can you explain model durability?

689


Explain how a source file is populated?

927


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1586


How we are using this function?

671






In sas, what are the areas that you are most interested in? : sas-grid-administration

725


What is the multi-insert?

703


How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

1626


why is a stop statement needed for the point=option on a set statement? : Sas programming

688


what is song in infrmatica...?

1811


Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days

3253


How would you define the end of a macro? : sas-macro

715


what are the considerations when picking a SAS/STAT procedure?

2994


Have you worked with/created Parameter file

1315


How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

627