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 will u remove header record? How will u remove tailer record?

EDS, Polaris,

5 28124

Hi friends if u don't mind i want one question What abt READ MULTIFILE COMPONENT? PLZ GIVE BRIEFLY?

2 11543

What is DSS?? (Defination of DSS)

2 7127

What is maximum number of promts we can give in a BO report?

Patni,

1 8401

How Union Transformation is an Active Trans?

6 20521

Can we start CMS server from CMC? Is yes can anyone tell me how plz Thanks in advance?

Barclays,

2 10066

What is the use of linling the universes?Thanks in advance

2 5974

What is a surrogate key?Why we use it in a mapping?Pl give an example.

PCS,

4 12581

when we will use connected Lookup & Unconnected Lookup

Wipro,

3 11489

which cache supports connected & un connected Lookup

Wipro,

1 5881

can we use sequential file as a lookup

Cognizant, Wipro,

7 24392

hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage

Wipro,

1 7395

what is Audit table?Have u use audit table in ur project?

Accenture, Wipro,

3 23764

how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

Wipro,

2 9077

How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?

Wipro,

2 8814

Un-Answered Questions { Data Warehouse }

write a query to retrieve the latest records from the table sorted by version(scd)

1125

What are the advantages of cold fusion?

1009

How to select first n records in teradata?

1167

Explain the term 'foreign key' related to relational database management system?

1120

What is the Rank index port in Rank transformation?

1105

What is the difference between %local and %global? : sas-macro

1243

What are the new features of informatica 9.x at the developer level?

1110

What is informatica architecture?

1114

Explain what are the various file formats involved in reportnet?

1026

What is the difference between group and associare?

1089

If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

1013

Explain difference between e-r modeling and dimentional modeling?

1040

Code the tables statement for a single-level (most common) frequency?

976

how to do user inputs and command line arguments in sas?

3095

Pdl with an example?

1160

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