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 , Today 1000 records updated, tomorrow 500 records updated how to find that?

Wipro,

4 13778

what is parameterset?

Wipro,

4 11357

j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?

Wipro,

1 6959

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?

Wipro,

2278

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

Wipro,

2676

1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?

Wipro,

7 20224

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

Wipro,

2081

I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?

3 6667

Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?

6 9147

If the Hi-rarchies are not defined in the universe level .Is it possible to do in the report level?

Infotech,

3 6531

Can we get the data from two different databasess in reporting level?

Infotech,

1 6065

What is the pivot option ? what is the need of it?

Infotech,

1 4929

How maually can i define ? If thousends of records exists in a table?

Infotech,

1 4983

Is it mandatory to give a cardinality ? If cardinality is not given what will happen?

Infotech,

4 11520

Can i use personal database connection to the Webintellegence reports?

Infotech,

1 4539

Un-Answered Questions { Data Warehouse }

Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?

1047

What is a materialized view log?

1049

Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

984

Can we create a node as a gateway node and the same node can be assigned to a grid?

1132

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

2411

How to create Index to the table in the universe designer and how it improves the Query performence

2619

WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

2321

Reusable transformation and shortcut differences

1884

what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

1197

What is Metrics designer?

1088

Can we take backup when the database is opened?

1108

Compare sas with other data analytics tools.

1112

what are the component of range? : Sas-bi

1155

What is the work of tranwrd function?

1309

What is drill down and slicing and dicing whats the difference between them?

1172

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