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 many universes will run maximum in single project

HP,

1 3813

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

Infosys, Wells Fargo,

4373

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

Amex,

2 4471

What is the most complex report you have developed. Explain and how did you overcome??? Please give some examples

NTT Data,

2 4455

What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.

2 15424

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

HCL,

1 3528

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

CTS,

2 4547

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

HCL,

1 4844

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

HCL,

4 7079

Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

TCS, Wipro,

4 7695

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

TCS, Wipro,

2012

How to move data set from one server to other?what are the steps to follow to do this?

2 4599

when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 6255

why less number of records in loop? why more number of records in traps?

Wipro,

1 3426

Can we create datasets by proc step ? (Proc contents, Means)?

2 3954

Un-Answered Questions { Data Warehouse }

What is job control?

1114

Explain the difference between view and materialized view?

943

How analytics process your request when you create your requests?

938

Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?

1228

What is bi?

1095

During the Display time, how is the sequence generated by Teradata?

1055

what are the types of interactive display types? : Sas-bi

1100

How to import vsam files from source to target. Do we need a special plugin?

935

Mention few power centre client applications with their basic purpose?

951

How do you reject records in a transformer?

1125

How do you truncate a table?

1173

Clarify the utilization of aggregator cache record?

1002

what is informatica metadata?

1037

Describe the architecture of datastage?

1010

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

1080

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