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

if we have a delimiters at unwanted places in a flat file how can we over come those.

2103

why should we go Teradata over Oracle,what is the main differences?

TCS,

4 12291

what is the hint? how to use it to reduce the query processing in program?

Cegedim,

3 8008

What are @FUNCTION?

4 8116

Why do we use QUIT commmand for proc datasets and proc sql ???

3 9155

1)Source file contains one record, I want 100 records in target file.

3 9489

Two source files contains same meta data third file contains different data types can I funnel that file.

2 8274

3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 6246

I have 100 records how can I load at a time from the single time

1 5369

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

2 6867

hi,can you please share with me about,what is reportlimit,report order and how can create and use

iGate,

1 5337

hi,can you share with me about,what is prompt order,how it uses and how it creates

1 5725

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

4 9075

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4104

How to schedule the report twice in a day?

Cognizant,

2 10128

Un-Answered Questions { Data Warehouse }

What are the data types does SAS contain?

1181

how does sas handle missing values in procs? : Sas programming

1362

Enlist the tasks for which source qualifier transformation is used.

1085

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

Where do you see different stages in the designer?

1157

Where are the source flat files kept before running the session?

1146

How to load data in informatica ?

1070

What are situations where snowflake schema is better than star schema when the opposite is true?

1046

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

1021

What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

1084

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

1300

What is difference between primary key and unique key constraints?

1035

What is meant by a Clique?

1125

How does microstrategy object manager determine if two projects are related?

1114

How do you remove duplicate values in datastage?

1204

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