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

my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

Zensar,

2 7175

can any one give some examples for pre sql and post sql(Except dropping and creating index).

Zensar,

4121

What is the difference between SOURCE and TARGET BASED COMMITS?

IBM,

3 6796

What happens if we dont select data driven option?

Zensar,

2 7682

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

IBM, TCS,

2020

how to create relationship between emp and salgrade tables in frameworkmanager?

TCS,

1 4927

how we can add header and footer to flat files?

Tech Mahindra, Zensar,

2 15312

how to abort the job its matain duplicates?

TCS,

2589

how can u find the granularity in fact table

iGate,

1 6113

What we need to discuss with designer before starting the universe designing.

BMC,

2264

when you have three fact table and there is no relationship between them. How you will tackle the issue.

BMC, TCS,

2 6280

can you use inputbox in BOXI. e.g. checkbox,textbox etc.

ACN, Patni,

1 4632

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

Patni,

2121

Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

BMC,

3102

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 6514

Un-Answered Questions { Data Warehouse }

Can we collect statistics on multiple columns?

1079

I know of using applysimple, but there are other ways too?

972

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1169

What are the commands to make a new table, change a table and remove a table in teradata?

1143

What is bi?

1106

I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

2029

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1804

According to you, what are the most important tables in a dw? Why?

1001

What is etl tool in hadoop?

909

How can we store previous session logs?

1097

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1146

What is model filter?

1234

Explain constraint based loading in informatica

1111

--------------Explain Table of contents?

2036

How were the reports scheduled and how to resolve unexecuted documents?

2691

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