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 can u convert this 25-jul-2010 from numeric to charcter?

3 7619

how to through logic of informatica using the push down optimization into oracle.

Hexaware,

2 7795

Is there any model difference between ODS and DWH

Zensar,

2 7351

How You Pull the records on daily basis into your ETL Server.

TCS,

2 7117

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

Mphasis,

2 15081

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

Zensar,

2 6775

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

Zensar,

1 7160

How you count the number of records available at your source?

Zensar,

3 14358

How you load distinct records into one target and duplicate records into another target?

Mphasis,

3 16638

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

HP,

5 11424

write a query to get maximum salary from the employers table without duplicates....kindly help me

CTS,

5 10078

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

TCS,

3 7266

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

HP,

3 9076

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

Qwest,

1 5898

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

CTS,

2 13986

Un-Answered Questions { Data Warehouse }

What are some different alternative commands associated with "dsjob"?

1170

where to store informatica rejected data? How to extract the informatica rejected data?

1008

What is the difference between the standard and metrics folder?

975

What is partitioning? What are the types of partitioning?

1173

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1967

What are the difference types of stages?

1219

What sort of existing documents should business analysts refer to when starting on a new project?

1010

Explain in detail about type 2(scd),

1107

what is the difference between microstrategy and cognos?

935

Explain what is type 2 version dimension?

1014

Why AWS redshift is named after Redshift?

What is the order of precedence of vldb properties?

1012

What is the difference between teradata and oracle?

1033

What is the difference between absolute filtering and standard filtering?

1054

Tell e how how dealt with..

2227

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