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

Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?

TCS,

3 18628

Can we use Round Robin for aggregator?is there any benefit underlying?

TCS,

3 9880

How to add zero "0" before record in a field?

4 26858

Where in report Studio's property pane can I find NoDataHandler?

1 6632

Can any body give the PDL with example?

Cap Gemini,

1 31755

can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

2140

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

2079

Hi, I have one dataset, could you please ans for this. id amount paid_amount 1 700 400 2 900 250 3 300 300 a 400 250 b 500 320 c 800 650 x 200 190 y 900 250 z 300 180 i want create new dataset having id and paid_amount who are paid high amount comparing amount. ex: 1d paid_amount 3 300 c 650 x 190

3 5050

when we are using the PROC TRANSPOSE? OBSERVATIONS are repeated then what will happen and what it will show in log window.

1 4660

What is audit table?

1 6499

Hi, I have one dataset like id date ex: id date 1 13 1 13Oct2011 2 14 2 14Oct2011 3 15 3 15Oct2011 --->this is the current date here i want date format like 13Oct2011,14Oct2011 how we can modify the numeric to date format plz answer.

4 6019

How we can create SAS USER DEFINED CODE?

2050

i have a macro variable var1,var2. i want titles for the each macro variable separately? how it is possible?

L&T,

1 4435

i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

L&T,

2455

i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?

L&T,

5 9980

Un-Answered Questions { Data Warehouse }

Describe the set operators in teradata.

973

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

1035

Explain teradata utilities. What is multiload, fast load, tpump?

972

How to create a repository in abinitio for stand-alone system(local nt)?

1084

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

906

Explain a mapping, session, worklet, workflow, mapplet?

1063

Nls stands for what in datastage?

1161

what is catalog and types of catalogs in cagnos and which is better?

1128

Differentiate between sessions and batches?

986

What are some examples of informatica etl programs?

908

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2013

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4160

What is a bo repository?

1012

What are the types of schemas we have in data warehouse.

924

Different qualification between a related rotate toward the sky and isolates look upward?

951

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