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 to unlock a locked job in datastage 8.0

3 23514

Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.

Cognizant, Wipro,

7 15641

hi, am put into Ab initio now. I need some material for to learn it!! i have to give a test also.. can anyone help me provide material please....

1 5023

What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

Altisource, Patni,

1 9910

What is synonym?

Patni,

2 6220

what is lookup chache?

Patni,

1 4910

what is the mechanism of the Master-Detail joining condition?

IBM, Patni,

6 10475

Do joiner transformation use cache? If so describe?

Patni,

2 7080

what is materialized view?

2 5348

How will you check the bottle necks in informatica? From where do you start checking?

HCL,

3 8032

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

HCL,

8284

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

1 3710

how to remove duplicates in transformer stage by using stage variables?one example?

Syntel, TCS,

6 34030

Can we Save (save as) WEBI Doc as DESKI?

HCL,

3 8347

You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?

2 5709

Un-Answered Questions { Data Warehouse }

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2169

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2766

What is a rollup component? Explain about it.

1242

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1212

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2093

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2175

Hi friends, what are the new features in abinito3.0?

2860

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2546

Explain in detail about scd type 1 through mapping.

1646

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1996

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3660

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1200

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2436

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2312

what are the names of the reports that you prepared?

1193

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