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 9500

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 13322

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 16591

waht is the advantage of infoset query

iGate,

2370

what is the diffrence between psa and idoc

iGate,

2282

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?

2946

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

IBM,

6 9796

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 10296

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

IBM,

3 12731

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

TCS,

1 5839

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 6459

performance wise which one is better in joiner and lookup transformation

2 6591

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

1 3835

which transformation uses cache?

Keane India Ltd,

3 7348

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 7004

Un-Answered Questions { Data Warehouse }

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1523

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6198

How would you identify a macro variable? : sas-macro

1032

What are the areas of application?

1161

What are the restrictions of union transformation?

1053

How does the bre work with the co>operating system?

1108

Can we take backup when the database is opened?

1062

What is orabulk stage?

1062

what is the meant by Normalization and de-normalization?

2725

What are the various types of transformation?

1197

What is a logical size of a table and what does it depend on?

985

How to limit decimal places for the variable using proc means?

1090

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1097

What do you understand by a term domain?

1136

What is AWS Redshift is used for ?

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