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 7171

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

Zensar,

4120

What is the difference between SOURCE and TARGET BASED COMMITS?

IBM,

3 6788

What happens if we dont select data driven option?

Zensar,

2 7676

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,

2016

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

TCS,

1 4921

how we can add header and footer to flat files?

Tech Mahindra, Zensar,

2 15301

how to abort the job its matain duplicates?

TCS,

2585

how can u find the granularity in fact table

iGate,

1 6107

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

BMC,

2257

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

BMC, TCS,

2 6275

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,

2115

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

BMC,

3094

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 6508

Un-Answered Questions { Data Warehouse }

Of all your work, where have you been the most successful?

4675

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

2058

How to hide certain columns from a user?

855

What are snapshots? What are materialized views & where do we use them?

1051

What is the scenario which compels informatica server to reject files?

1084

How can we run the graph?

1081

What is meant by lookup transformation?

1124

What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?

1043

how to merge 2 crosstabs thans

2650

What are Non-additive facts?

1177

What is aggregate fact table?

999

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3805

Explain what are the different types of transformation available in informatica.

1162

What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

1018

What is the difference between absolute and relative div positioning?

1062

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