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

How to use Environment variable's in datastage?(use of process)

1 7709

Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 7144

what is the difference between Ranking and sort-out in bo?

iNautix, TCS,

2 14930

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

TCS,

2280

what are the different ways of merging two datasets.name atleast 4.

2 6099

How many types of models are present in cognos.?

4 11177

what is the use of surogate key in datastage

TCS,

2310

hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz

4 8983

what is the use of surogate key in datastage

3 9475

Plz can any one say me how to get the informatica certification materials and dumps

TCS,

2050

why normalizer transformation can not used in mapplet? plzzzz answer

Syntel,

2 15200

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

IBM,

2 6921

what is stitched query???

IBM,

2 6354

what is Galaxy schema??

IBM, iGate, Wipro,

2 8825

when we have to go for a sequential file stage & for a dataset in datastage?

1 5129

Un-Answered Questions { Data Warehouse }

If you use a symput in a data step, when and where can you use the macro variable? : sas-macro

1088

What you know about transaction control transformation?

996

Can you state some of the innovations throughout history?

984

What are the implications?

1717

What is an Integration service in Informatica?

1136

What is the method of removing duplicates, without the remove duplicate stage?

1029

what is Active lock explain

2804

What are the difference between snow flake and star schema?

1006

--------------Diff b/w ODS and OLAP?

3208

What is your favorite all time computer book? Why?

2510

What is difference between user and database in teradata?

1074

What are consolidations?

910

How to design file watch jobs?

974

Why is auto-regression used in forecasting used on cognos platform?

1021

How can we use mapping variables in informatica?

1064

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