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,

2290

how do u reduce warnings

CGI,

1 8149

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

3022

How do you get log info into a file?

1 3484

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

2501

What is Cleanup Resources and when do you use it?

2 8602

How to remove blank spaces from data?

3 13345

how will u design file watch jobs?

2 7625

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

2856

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 10889

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 9125

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 4857

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

2321

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

TCS,

4 23861

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

TCS,

2 7598

Un-Answered Questions { Data Warehouse }

What versions of SAS have you used (on which platforms)?

1571

difference between repository database and repository service?

1228

What is the difference between informatica 7.0 and 8.0?

1054

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1123

What a static and local variable?

1139

What is confirmed fact in dataware housing?

7111

how do u set partition points in the mapping?

2303

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1321

--------------Diff b/w ODS and OLAP?

3253

What is the use of the %include statement?

1217

Name different type of objects in microstrategy?

971

What we will do with the universe for faster process?

1036

Can you explain players in datastage?

1254

How you will check the version of teradata?

1228

What are level metrics? Why are they needed?

1092

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