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 we khow a database is connected in Abinitio?

2 15100

my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?

TCS,

3 9507

pls ans what are the filters we have in framework manager? filters in report studio?

IBM,

3 14394

source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.

2 7454

souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2

9 12312

Performance wise which is better joiner or look up ? Give me with example?

CGI,

1 11287

what is surrogate id ?

IBM,

3 8427

How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?

3 9446

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2107

Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

IBM,

2 9765

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

IBM,

2366

What is best approach to load 100 different source files (Different structure) to differet target tables ?

IBM, TCS,

2 10978

How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

IBM,

2 10040

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

IBM, WalMart,

2 8901

What are the Aggregate functions in SQL ?

AON,

2 8120

Un-Answered Questions { Data Warehouse }

Define data warehouse?

1048

What are the types of schemas we have in data warehouse.

963

What can be achieved by using the teradata rdbms?

1039

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro

1067

Can you explain the co>operating system’s processing model?

1103

what is sas business intelligence? : Sas-bi

1183

What is the difference in the way microstrategy handles custom group and consolidations?

1001

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2388

What do high confidence, low confidence and no confidence mean in explain plan?

1048

What are slice and dice?

930

explain the difference between proc means and proc summary?

1130

Explain substr function?

1116

what are several options for creating reports in web report studio? : Sas-bi

1159

What is dimension modeling?

1090

What is DR strategy for Informatica project?

1190

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