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

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

Wipro,

2233

how do u reduce warnings

CGI,

1 8043

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2970

How do you get log info into a file?

1 3415

Different ways a project can be moved to production ?...example â€¦.export-import and Version control.

2449

What is Cleanup Resources and when do you use it?

2 8468

How to remove blank spaces from data?

3 13187

how will u design file watch jobs?

2 7506

how do u catch bad rows from OCI stage? And what CLI stands for?

2800

if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

5 10713

if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????

3 8985

PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 4750

hi real timers . iam waiting for ur reply regarding ETL TESTING

2271

Can we update a target table (without primarykey) by using update strategy transformation?

TCS,

4 23671

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

TCS,

2 7454

Un-Answered Questions { Data Warehouse }

Define orabulk and bcp stages?

1122

What is level metrics in microstrategy?

1031

What is surrogate key? Where we use it? Explain with examples.

1027

Tell me what is degree of a relation?

997

What are the best sas programming practices for handling very large datasets? : sas-grid-administration

1016

What is meant by junk dimension?

1183

What are the data types that sas contain?

1186

explain about citrix scheduling tool in datastage

2457

What the difference is between a database, a data warehouse and a data mart?

1155

Can you define snapshot?

924

tell me two or three issues from client side and how to solve those issues?

2167

Briefly describe lookup transformation?

1046

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

1019

What would you change about your job?

2388

What are stage variables, derivations and constants?

1228

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