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

Hi, I am Searching on Cognos 8, I don't know how to explain the projects in cognos.Can anybody help me in this regard. My email id is hchereddy@gmail.com. Thanks in advance

IBM,

1988

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

TCS,

2 9515

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 8870

How are parameters defined in informatica?

HP, TCS,

3 10230

What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?

TCS,

2 14842

What is sql query override? When did u use sql query override?

TCS,

1 7129

Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M

JPMorgan Chase,

6 13715

Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 13953

Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance

2 4093

what is sysdba and sysdbc ? which has high priority ?

Wipro,

3888

which utitility can use for loading the data from non-teradata to teradata ?

Wipro,

5 13623

what is differences between Fastload and Multiload as per DBA aspect ?

Wipro,

1 7141

what is single value and Multivalue ?

IBM, Wipro,

1 6472

we have package it contain Query subject (123456). If u generate report with 6 query subject error will occure how to resolve this problem

IBM,

1 4848

I have prompt date prompt (from and to), country and city, how to get data from jan1/2012 to jan31-2012.

IBM,

2 6915

Un-Answered Questions { Data Warehouse }

Describe the architecture of datastage?

1065

Briefly explain input and put function?

1140

What do you mean by Drill down and Drill Up?

1055

What are the functionalities of link partitioner?

1071

Can you explain engine tier in information server?

1191

I know of using applysimple, but there are other ways too?

1000

What are the types of schemas we have in data warehouse and what are the difference between them?

991

How do we drill through from a powerplay cube to reportnet?\

2405

What are situations where snowflake schema is better than star schema when the opposite is true?

1038

What do you mean incremental aggregation?

1131

how to load dimension table and fact table. plz tell me the steps.

2149

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2204

How the users created differs from rpd/answers/dashboards level?

854

What is difference between content store and content manager?

1030

What are the limitations of amazon redshift?

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