Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

create a mapping to retrieve the employees who are getting salary greater than average salary?

TCS,

4 10993

which join mostly use in realtime?

TCS,

2 8151

How to copy teradata scripts from ur remote desktop to server machine?

3 7903

how to load or extract the error table data ?

3 7639

what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)

4 16205

which option is used to restart the fastexport script ?

TCS,

2 10138

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

2204

what do you mean by INMOD Routines and OUTMODE Routines ?

3 12908

I HAVE MONTHS AS DEC,JEN,MAY,APRIL... WHICH PROMPT IS USED TO GET REPORT IN SEQUENCE?

Patni,

2 8348

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 20338

i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?

IBM,

4 9182

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 6940

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

CSC,

4 9148

what is the difference between 7.1,7.5.2,8.1 versions in datastage?

IBM,

3 10158

what is different daily and monthly develop the abinitio graphs?

TCS,

1 5496

Un-Answered Questions { Data Warehouse }

Explain fact degradation?

998

What are aggregate transformation?

1043

How to import vsam files from source to target. Do we need a special plugin?

937

client know skid info?

2088

What are the advantages of using cognos sql?

1195

What is maximum number of rows and cols can be handled in SAS?

1593

How we can create SAS USER DEFINED CODE?

2102

where to use sas business intelligence? : Sas-bi

1093

what is Forward,Reverse and Re_engineering?

2261

How to join three sources using joiner? Explain though mapping flow.

1151

If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1498

What is a macro routine?

2732

What is substr function?

1197

How to do Performence Tunning in Cognos Reports?

2477

What is standalone command task?

1319

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