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

Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?

IBM,

2 9469

How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????

Mphasis,

3 13283

In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??

CTS, Lexicon,

3 16555

waht is the advantage of infoset query

iGate,

2363

what is the diffrence between psa and idoc

iGate,

2272

How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2929

how may sources can be used in a mapping at a time?(limit)

IBM,

6 9753

what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

IBM, ITC Infotech,

3 10267

What is the default layout of a component ? Is it mandatory to set the layout of a component ?

IBM,

3 12706

What is the difference between a router and a filter transformation?

TCS,

1 5822

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

BirlaSoft,

2 6443

performance wise which one is better in joiner and lookup transformation

2 6565

Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT SAS Training in Data Management at InfoSchool Bangalore

1 3814

which transformation uses cache?

Keane India Ltd,

3 7325

suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

emc2,

2 6987

Un-Answered Questions { Data Warehouse }

Difference between informatica vs ab initio?

1309

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2204

Can you explain repository tables in datastage?

1408

In the Primary Index, what is the score of AMPs that are actively involved?

1078

How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?

2460

How can I run the 2 gui merge files?

1179

In informatica workflow manager, how many repositories can be created?

1361

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1776

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

986

What is dtm?

1169

What are the functionalities of link partitioner and link collector?

1009

which type of project we r going to snowflake schema

1978

What can we do with datastage director?

1238

Differentiate between datastage and datastage tx?

1051

We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2525

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