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 do you load 10 different sources with 10 different layouts to 10 different tables?

TIAA CREF,

1 7445

what is the difference between cubes and package in cognos

Cognizant,

1 5020

What is the difference between List and Cross tab? Could some on explain with an example..

Barclays,

2 7572

Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??

Barclays,

2 8413

Which one among Star and snowflake schemas will occupy more space?

Barclays,

1 8457

what is operator combinality in datastage?

TCS,

1 7615

Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.

IBM,

2 7077

Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.

IBM,

1 5993

Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

IBM,

3 9315

Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

Cap Gemini, IBM,

2 9804

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

CGI,

1 2595

Can we use two different sources in webirich client to create A report ? Like universe and excel etc...

PWC,

3 8022

WHAT IS INPUT CONTROL IN BO?

PWC,

3 10881

IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?

Accenture,

1 7564

i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.

1 4623

Un-Answered Questions { Data Warehouse }

draw informatica architecture 8.6 ?

3951

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

1771

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

848

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2268

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1245

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1214

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

2314

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2179

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

What is dimensional table?

1168

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

1219

what are the names of the reports that you prepared?

1203

create a job that splits the data in the Jobs.txt file into four output files. You will direct the data to the different output files using constraints. • Job name: JobLevels • Source file: Jobs.txt • Target file 1: LowLevelJobs.txt − min_lvl between 0 and 25 inclusive. − Same column types and headings as Jobs.txt. − Include column names in the first line of the output file. − Job description column should be preceded by the string “Job Title:” and embedded within square brackets. For example, if the job description is “Designer”, the derived value is: “Job Title: [Designer]”. • Target file 2: MidLevelJobs.txt − min_lvl between 26 and 100 inclusive. − Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt − min_lvl between 101 and 500 inclusive. − Same format and derivations as Target file 1. • Rejects file: JobRejects.txt − min_lvl is out of range, i.e., below 0 or above 500. − This file has only two columns: job_id and reject_desc. − reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: ”, where is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows.

2819

What is a rollup component? Explain about it.

1246

Demonstrate experience in maintaining quality process standards?

2677

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