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 11192

which join mostly use in realtime?

TCS,

2 8307

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

3 8043

how to load or extract the error table data ?

3 7790

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

4 16387

which option is used to restart the fastexport script ?

TCS,

2 10258

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

2270

what do you mean by INMOD Routines and OUTMODE Routines ?

3 13058

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

Patni,

2 8466

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

6 20619

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 9357

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 7064

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 9336

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

IBM,

3 10325

what is different daily and monthly develop the abinitio graphs?

TCS,

1 5594

Un-Answered Questions { Data Warehouse }

How many bi services node can be clustered together?

928

What is the difference between operational data stage (ods) and data warehouse?

1300

What leads to a cross-join or how does a cross-join occur?

1002

design of staging area?

2085

what are the benefits of data integration? : Sas-di

1193

How Metrics Studio is better than Report Studio?

2698

What is pmcmd command?

1187

What is a difference between complete, stop and abort?

1132

What is the use of datastage designer?

1237

Write different kinds of objects in microstrategy?

1042

What is the difference between datastage and datastage tx?

1129

I generated one report design time I can color green. At run I want bule how to change dynamically? And which method I can over write?

1047

What is the project in datastage?

1176

What is resilience time?

1237

What’s the use AWS redshift cluster Service?

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