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 7309

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

Zensar,

1 4178

What is the difference between SOURCE and TARGET BASED COMMITS?

IBM,

3 6922

What happens if we dont select data driven option?

Zensar,

2 7859

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,

1 2083

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

TCS,

1 5019

how we can add header and footer to flat files?

Tech Mahindra, Zensar,

2 15496

how to abort the job its matain duplicates?

TCS,

1 2654

how can u find the granularity in fact table

iGate,

1 6250

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

BMC,

1 2321

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

BMC, TCS,

2 6445

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

ACN, Patni,

1 4709

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

Patni,

2169

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

BMC,

1 3150

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 6629

Un-Answered Questions { Data Warehouse }

what is document design in boxi,have u participate in that

2308

Are you involved in writing the inferential analysis plan? Tables specifications?

4019

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1771

what are the data modeling tools you have used?(polaris)

2060

Explain scd type 3 through mapping.

1076

What are the data types present in bo? What happens if we implement view in the designer and report?

1082

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2495

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3666

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2772

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1202

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2313

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2550

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4194

Have you have ever worked in unix environment and why it is useful in datastage?

1217

Hi, If anyone has base SAS certification dumps, please share.

1941

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