Data Warehouse Interview Questions
Questions Answers Views Company eMail

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

CTS,

963

CHANGE CAPTURE

CTS,

887

AGGREGATOR default datatype

CTS,

931

Have you used Unstructured data?

CTS,

826

Triggers,VIEW,Procedures

CTS,

796

How to RD using transformer?

CTS,

855

How to Remove Duplicate using SQL?

CTS,

839

Lookup constraints

CTS,

837

Difference between JOIN,LOOKUP,MERGE?

CTS,

2 2204

EXPLAIN SCD

CTS,

954

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

CTS,

953

Terminate Activity

CTS,

835

Notification Activity

CTS,

894

How to reverse the string using unix?

CTS,

2800

How to reverse the string using SQL?

CTS,

886


Un-Answered Questions { Data Warehouse }

Explain absolute filter?

573


Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

539


how do you use tm1 cubes in framework manager?

5


What are the uses of sas?

698


Write the unconnected lookup syntax and how to return more than one column.

590






While migrating the data from one environment to another environment how would you manage the connections?

622


Why do we need informatica?

552


How we are using this function?

593


What does update strategy mean, and what are the different option of it?

584


You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?

514


Explain fact degradation?

599


What are the types of jobs we have in datastage?

663


define galaxy repository in informatica

1721


how get the grand total in master-detail report?

1812


What is the difference between aggregate table and materialized view?

594