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 5640

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

CST,

2317

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

Banking, Genpact, TCS,

4791

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

Wipro,

3 13619

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 7253

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 8482

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

CSC,

10 34856

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

5 7856

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

7 19012

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 6707

can anybody mail me the FAQS for hyperion essbase amd planning

DataMonitor,

5709

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

IBM,

7 16611

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

WNS,

2 7098

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 7920

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

2 5482

Un-Answered Questions { Data Warehouse }

Can any one explain the hierarchies level data warehousing.

1044

Approximately what date is represented by the SAS date value of 730?

1275

how do u handle performance issues in Informatica . where can u monitor the performance ?

4793

What is persistent lookup cache?

1101

Have you used Unstructured data?

1377

What is flashback table ? Advance thanks

2001

What are the steps involved after the disk manager passes the request?

1188

What are routines in datastage? Enlist various types of routines.

1154

What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

974

What is status code in informatica?

1067

Name and describe few sas character functions that are used for data cleaning in brief.

1187

Mention the validation tools used in SAS?

1236

How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC

2080

What is the sequence generator transformation in informatica?

1268

What is the model filter?

1079

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