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

hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.

IBM,

4 13189

,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

Emphasis,

3 8008

2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?

Emphasis,

2 6376

what is curr val use for in sequence generator?

Emphasis,

2 7554

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

Emphasis,

1 4854

what is the necessity to use update strategy?(except for updates)

Emphasis,

2 6315

What is the method of seperating unique and duplicate records in session level?

Emphasis, JBL, Wipro,

2 10253

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

Accenture,

6 11837

what is the difference between a data item and a query item?

Bodhtree, HP,

2 15420

I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know

6 9687

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

IBM,

2243

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

IBM,

5 11665

HOW TO PUBLISH A REPORT IN BO?

Polaris,

1 7128

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

TCS,

1 5790

How do you find what type of trap is there by seeing the report?

TCS,

4 7487

Un-Answered Questions { Data Warehouse }

What is the different type of jobs in datastage?

974

client know skid info?

2082

How we check the errors before running the report?

998

What is microstrategy?

974

what will be the contents for a functional requirements specifications

2354

how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

2110

How you can differentiate between connected lookup and unconnected lookup?

1062

Explain why fact table is in normal form?

970

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2967

What is the format of informatica objects in a repository?

1019

explain html document?

1007

What is difference between content store and content manager?

976

Explain the use lookup tables and Aggregate tables?

977

Define pmcmd command?

1040

What are the reusable transformations?

1162

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