Data Warehouse Interview Questions
Questions Answers Views Company eMail

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

CTS,

952

CHANGE CAPTURE

CTS,

879

AGGREGATOR default datatype

CTS,

925

Have you used Unstructured data?

CTS,

824

Triggers,VIEW,Procedures

CTS,

788

How to RD using transformer?

CTS,

850

How to Remove Duplicate using SQL?

CTS,

830

Lookup constraints

CTS,

831

Difference between JOIN,LOOKUP,MERGE?

CTS,

2 2190

EXPLAIN SCD

CTS,

949

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

CTS,

947

Terminate Activity

CTS,

833

Notification Activity

CTS,

890

How to reverse the string using unix?

CTS,

2787

How to reverse the string using SQL?

CTS,

881


Un-Answered Questions { Data Warehouse }

Your i-sever crashed. What will you do?

639


How do dates work in SAS data?

672


Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

1683


What are the types of schemas we have in data warehouse and what are the difference between them?

512


How to manage date conversion in Datastage?

630






Explain about cumulative Sum or moving sum?

614


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1192


Explain difference between powerplay transformer and power play reports?

533


why is sas considered self-documenting? : Sas programming

672


How do we execute sql file on redshift?

1


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

624


What is dynamic cache?

602


What is SAS?

609


what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?

3361


Can you define report item?

584