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 anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

IBM,

4788

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

IBM,

2 7357

what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-

4 23506

what is the best stage in datastage parller jobs to use full out join and why

Virtusa,

5 16166

I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

Virtusa,

3 13096

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2271

How can we load single row of data into teradata database. please give me the process.

3 10156

without dynamic lookup transformation how to insert new rows and update existing rows?

Cap Gemini,

7 16903

one source to target loading insert new rows and update existing rows?

Polaris,

3 7580

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

L&T,

7 14151

Which is the best place to learn SAS clinicals and Oracle clinical in hyderabad?

2 5498

Please some body send me Ab Initio material in my mail ... sitakanta2009@gmail.com Thanks in Advance!!!

1 5368

What is the language used in Ab Initio ?

4 15896

i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

L&T,

5 12646

if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

BirlaSoft, Genpact, L&T, Syntel,

9 17401

Un-Answered Questions { Data Warehouse }

What is informatica metadata and where is it stored?

1056

What is analytical or analytic mean?

1198

what is ds administrator used for?

1224

What is dynamic cache?

1091

What are the other methods working as deployment functionality?

999

How is the teradata different from oracle?

1174

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2139

Why union transformation is an active transformation?

1109

generate date / time dimension in informatica

1170

What do mean by local and global repository?

1286

How to generate iqd file from framework manager?

1023

Does AWS Redshift use SQL?

What is intricate mapping?

1332

How many bi services node can be clustered together?

930

Write the unconnected lookup syntax?

1138

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