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 will u remove header record? How will u remove tailer record?

EDS, Polaris,

5 27659

Hi friends if u don't mind i want one question What abt READ MULTIFILE COMPONENT? PLZ GIVE BRIEFLY?

2 11324

What is DSS?? (Defination of DSS)

2 6886

What is maximum number of promts we can give in a BO report?

Patni,

1 8151

How Union Transformation is an Active Trans?

6 20042

Can we start CMS server from CMC? Is yes can anyone tell me how plz Thanks in advance?

Barclays,

2 9820

What is the use of linling the universes?Thanks in advance

2 5738

What is a surrogate key?Why we use it in a mapping?Pl give an example.

PCS,

4 12251

when we will use connected Lookup & Unconnected Lookup

Wipro,

3 11155

which cache supports connected & un connected Lookup

Wipro,

1 5692

can we use sequential file as a lookup

Cognizant, Wipro,

7 23851

hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage

Wipro,

1 7207

what is Audit table?Have u use audit table in ur project?

Accenture, Wipro,

3 23406

how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

Wipro,

2 8814

How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?

Wipro,

2 8609

Un-Answered Questions { Data Warehouse }

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

1016

Explain about the data integration suite features?

878

What do mean by local and global repository?

1159

What is Operational Data Store?

1007

How will you create interactive dashboards ?

854

what is the difference between the report filter and report limit?

910

Explain about power designer data modeling software?

801

Tell me what is degree of a relation?

940

how to connect to a flatfile through ftp in informatica

14183

What are the design methods of data warehousing?

899

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4073

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2156

How will you move hashed file from one location to another location?

2099

What would be the next step after collecting the data?

1150

What are key differences between sql server and amazon redshift?

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