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 create prompts in report net?

1 1067

What is the difference between power center and power mart?

1 1101

What is the difference between filter and lookup transformation?

1 1199

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

1 1041

In document how to create metrics?

1 1058

Is union transormation is active transformation?

1 1047

How to join 3 database like flat file, oracle, db2 in informatrica?

1 1370

How to import vsam files from source to target. Do we need a special plugin?

1 1018

What is edw?

1 1308

Code the tables statement to produce a multi-level frequency?

1 1074

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1 1152

why use references rather than pointers in the public api, particularly for arguments which are modified?

1 1072

What is stored procedure in teradata?

1 1109

What is data transformation manager process?

1 1255

How do you change a non-reusable transformation to reusable transformation?

1 1069

Un-Answered Questions { Data Warehouse }

Explain about a tricky situation for which you found a very simple solution?

1077

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

1212

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1100

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1670

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

2436

How would you format some text using css to be verdana and bold?

1147

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

2312

explain in detail about type 3?

1083

What is the purpose of Dataware Control?

1120

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2167

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

How to add default rules in transformer?

1284

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 ?

2084

what are the data modeling tools you have used?(polaris)

2057

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2207

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