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

What is meant header and tailer, suppose header and tailer had some junk data how will delete junk data ? which components r used?

5 13950

what is hash file in abinitio? how will it read in abinitio? in hash file the data files r combine (file1.dat,file2.dat,file3.dat......etc) how will it divide?

HP,

2 15209

what is decoding & what is NVL?

1 10667

how will i can implemate Insert,Update,delete in abinitio? how will u view MFS in unix?what is diff/btween conditional dml& conditional component?

IBM, Syntel,

3 31362

can we create index and drop index in exsisting table while using infomatica

4 20017

"Change cache" in Informatica ?

2 7635

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 15956

What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 19317

What is the difference between Proc tabulate and Proc print

CitiGroup,

4 13024

How to convert a given date value into SAS date

CitiGroup, Quintiles,

9 39084

I want to do on drill calculation? Actually My report is like Continent Amount(Global Currency in dollar) ASIA 200 UK 100 On Drill ASIA Country Amount INDIA 5712(120*47.6) SINGAPORE 128(80 * 1.6) On Drill INDIA State Amount DELHI 3712 CHENNAI 2000

2 4995

What is Universe?

1 5016

What is Designer?

2 5014

How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

2445

Can any one tell me cognos training class in chennai? thanks in advance...

5 7695

Un-Answered Questions { Data Warehouse }

Which command is used to perform sorting in sas program?

1047

Explain the difference between union and group?

1100

What are the operations that support avoiding duplicate record?

1443

Does an informatica transformation support only aggregate expressions?

1042

Describe routines in datastage? Enlist various types of routines.

1015

what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

2318

Explain me what are conformed dimensions?

1029

what does the run statement do? : Sas programming

1057

explain about citrix scheduling tool in datastage

2457

I'm busy writing a report that's using report bursting, to be able to do this I need to use a sequential section. Using a sequential section cause the grouping of the original report not to work. Please can someone give me advise on how to come past this problem, the report need to use grouping as it depend largely on totals ect, and I need to use a sequential section within the report to be able to use the report bursting facility.

2776

why is sas data integration studio important? : Sas-di

1035

Where is teradata rdbms used?

1097

What does edp stand for?

1157

What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?

1235

Intern stastical programmer written test

752

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