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

write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

Bank Of America,

4 8955

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2249

what is the difference between copy object import objects using repositery manager which one is best

TCS,

1 4145

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

TCS,

2263

in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify

Patni,

3 7441

in realtime which situations u can use unconnected lookup transformation

Patni,

2 8301

in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

Patni,

3 9927

i have source in oracle 10g,oracle 8i how will u take the data from two sources

TCS,

2 5055

why we are using surogate key in real time give me explanation

TCS,

2 7124

How informatica process data means how informatica works?

TCS,

2 13176

Can we run session without using workflows?

TCS,

5 22332

how many modules are there in telecome domain?how to explain the architecture?

2029

Can you calculate the mean, median and mode of the following data set using data step logic? Don't use any function or procedure. data a; input age @@; datalines; 22 32 32 32 43 23 24 56 45 54 28 29 27 26 25 28 30 20 18 37 36 47 46 56 19 20 ; run; I have calculated the mean which i have posted in the answer section.

HSBC,

6 18612

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

HCL, HP,

2 7843

what is the location of parameter file in informatica?

TCS,

1 8479

Un-Answered Questions { Data Warehouse }

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

2215

Mention what is a partition and what are the different types of partition components in abinitio?

1196

Explain attribute role?

1102

Define datastores in cognos?

964

What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?

1110

Mention what are the data types does SAS contain?

1162

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2140

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1975

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?

1052

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1426

generate date / time dimension in informatica

1136

Can we use target hash file as a lookup ?

3340

How will the AWS redshift work?

Differentiate between a database and data warehouse?

1156

What is Analysis Services?

2153

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