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

what are the transformations that restricts the partitioning of sessions?

1 8958

What is Performance tuning in Informatica?

CTS, GE, TCS,

1 43645

What is power center repository?

1 11821

How can u work with remote database in informatica?did you work directly by using remote connections?

2 8750

What are the new features in Informatica 5.0?

1 4829

what is incremantal aggregation?

1 6037

What are the scheduling options to run a sesion?

2 11511

What is difference between stored procedure transformation and external procedure transformation?

2 14457

Explain about Recovering sessions?

1 6116

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 18904

How to recover the standalone session?

2 7165

How can you recover the session in sequential batches?

1 9708

How can you complete unrcoverable sessions?

1 5525

What are the circumstances that infromatica server results an unreciverable session?

1 5202

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 7825

Un-Answered Questions { Data Warehouse }

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2868

How would you increase the logical size of a table in microstrategy?

976

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2102

What is rank transformation in informatica

1180

From where u get the logical query of your request?

781

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2205

What are universe requirements?

1052

What is the use of function Proc summary?

1290

I have a flat file, want to reverse the contents of the flat file

1130

What are teradata utilities?

1115

in sap bi we have wad, then why we go for sap bo

3383

Tell me what is degree of a relation?

1002

How can we check the version of Teradata that we are using currently?

1070

Suppose you find the term validation mentioned with a set of data, what does that simply represent?

1040

Explain star schema?

987

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