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 7627

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

Hexaware,

2 7812

Is there any model difference between ODS and DWH

Zensar,

2 7367

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

TCS,

2 7129

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

Mphasis,

2 15089

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 6787

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 7172

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

Zensar,

3 14378

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

Mphasis,

3 16655

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 11443

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

CTS,

5 10101

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 7281

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 9092

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 14002

Un-Answered Questions { Data Warehouse }

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

2144

can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

2081

Explain rw document?

1108

what are the different authentication modes available in microstrategy?

1128

Name the third party tools that can be used in datastage?

1096

What a static and local variable?

1091

What are the different lookup cache(s)?

1132

Why do we use exception activity in Datastage?

1331

The methods to improve performance of a graph?

1090

Scheduling properties,whats the default (sequential)

1971

What are the main features of Oracle 8i with context to datawarehouse?

2124

For what purposes have you used sas macros? : sas-macro

1014

what is a prompt value in report studio and variables ?

2728

What are the co> operating system’s assorted library of integrated components?

1130

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1400

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