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 we migrate from Businees Objects reports to Cognos 8.x??

1 5577

8. How much supervision have you typically received in your previous job?

CST,

2255

How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

Banking, Genpact, TCS,

4717

1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?

Wipro,

3 13492

hi guys, i think this would be a simple question but i was asked. what is total time taken to develop a report from getting requirement document from the client? dont reply as it depends,i am expecting something else.

WNS,

2 7107

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

CSC,

3 8352

Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

CSC,

10 34516

I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 7660

What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 18759

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 6581

can anybody mail me the FAQS for hyperion essbase amd planning

DataMonitor,

5646

Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin

IBM,

7 16370

if at all asked.wat is u r cube name?wat would be a appropriate answer? plz help me

WNS,

2 6999

in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it should be displayed in (yyyy/mmm/dd)format. how could I do this plse send me as soon as possible.

3 7774

use scheduler to refresh report.....explain please.....

2 5377

Un-Answered Questions { Data Warehouse }

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2867

how many types of viewers available in tm1?

How to create a permanent sas data set?

1239

What are the types of views in datastage director?

1772

Explain the mapping variable usage example in informatica

1158

State the difference between INFORMAT and FORMAT ?

1107

What is the function of etl when used in data warehousing?

960

How can we run the graph? What is the procedure for that?

946

What are the features of base sas system?

1066

Explain the shared cache and re-cache?

1117

Enlist the differences between database and data warehouse.

1120

Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1955

How we can create SAS USER DEFINED CODE?

2096

Is there any difference in testing database and data ware housing?

2762

How to execute the plsql procedure from the report by clicking with mouse?

1131

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