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,

4727

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 7198

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

4 23319

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

Virtusa,

5 15925

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 12954

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

2224

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

3 10016

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

Cap Gemini,

7 16625

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

Polaris,

3 7371

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

L&T,

7 13838

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

2 5370

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

1 5280

What is the language used in Ab Initio ?

4 15655

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 12371

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 17050

Un-Answered Questions { Data Warehouse }

what is user variable in affinium campaign? and some real time examples.

4181

What steps should be taken to improve Datastage jobs?

1073

what is the custome stage in datastage? how can we impliment that one? plz tell me

2367

--------------Diff b/w ODS and OLAP?

3205

Describe in detail about lookup?

1088

Suppose we do not group by on any ports of the aggregator what will be the output?

1041

What is a predefined event?

1093

it will become easy if uuu provide website linkssss and list of consultanciessssss

1978

What is a staging area? Do we need it? What is the purpose of a staging area?

996

Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

2061

Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

2046

What are the factors on which storage of data depends?

1166

U r project in which stage in implementation?

2514

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 ?

2024

Do you know what a local lookup is?

1207

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