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

WHAT DOES A SAS SPECIFICATION DOCUMENT SDS CONTAIN ?

1 4698

WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?

Ericsson, Nokia,

4 12255

How to delete the data in dataset?types of deleting the data in dataset?

HSBC,

4 25035

we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

HSBC, NTT Data,

1 17031

tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?

Infotech,

3 8980

i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?

HSBC,

5 12857

hi Cognos Experts Pls Expalin me what is the diffence between list report query and crosstab report query?pls explain me.....

HCL,

1 5441

hi How Can we create rank in our report?i feel difficulty pls expain me with ex,pls pls........

2 6148

hi, i am Having 2 Reports one list report,one crosstab report if i put 2 querys for 2 reports which query will execute first?if i put same query for both 2 which report i will Get?pls pls pls Explain me...

IBM,

1 5268

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 3974

Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....

1 3771

hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?

1 3920

what is data driven in informatica

IBM,

5 9701

what is distinct

4 6326

How to import BIAR file in bo?

Emirates, Zensar,

1 9341

Un-Answered Questions { Data Warehouse }

What is proc sort?

1317

What is decode in informatica?

1260

How to join three sources using joiner?

1201

Explain what is the difference between a primary and secondary actor in use case modeling?

1122

What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1849

How to improve session performance in aggregator transformation?

1032

Can I access intelligent cubes without olap services?

1112

Explain what is fact less fact table? Where you have used it in your project?

987

Explain what is data step?

1244

Which development components of informatica have the highest usage?

1102

Explain difference between powerplay transformer and power play reports?

1002

What are the advantages of cognos?

1036

What is a filter transformation?

1097

What is TPD?

1426

What are the Types of parallelism in detail?

1195

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