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 11184

which join mostly use in realtime?

TCS,

2 8300

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

3 8035

how to load or extract the error table data ?

3 7783

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

4 16378

which option is used to restart the fastexport script ?

TCS,

2 10252

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

2268

what do you mean by INMOD Routines and OUTMODE Routines ?

3 13052

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

Patni,

2 8459

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

6 20605

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 9348

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 7063

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 9332

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

IBM,

3 10321

what is different daily and monthly develop the abinitio graphs?

TCS,

1 5594

Un-Answered Questions { Data Warehouse }

Which studio is used to create reports?

1162

What is data analysis?

1012

If a variable contains only numbers, can it be a character data type?

1150

how to sort two columns in single job in datastage.

2964

Start a batches with in a batch?

1038

Define Dynamic push down optmization?

2361

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2103

Explain the definition of normalized and denormalized view and what are the differences between them?

982

which r the connectors used in san?

2236

What are query items?

1082

What do the mod and int function do? : Sas programming

1317

What does the RUN statement do?

1358

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1974

Mention what is the difference between nodupkey and nodup options?

1069

what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

11031

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