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 4626

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

Ericsson, Nokia,

4 12112

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

HSBC,

4 24833

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 16929

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

Infotech,

3 8872

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 12650

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

HCL,

1 5350

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

2 6048

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 5188

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 3894

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 3674

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 3848

what is data driven in informatica

IBM,

5 9513

what is distinct

4 6175

How to import BIAR file in bo?

Emirates, Zensar,

1 9265

Un-Answered Questions { Data Warehouse }

What is the difference between formal and export parameter? Export at what secenario we are going to use?

2639

Please let me know how to make Data masking in informatica..

1726

what are logical views used for?

1011

which type of project we r going to snowflake schema

1978

Tell me more about the parameters in macro? : sas-macro

1053

What is MPP. Is Redshift support MPP?

Why need staging area database for dwh?

1081

What are the types of facts in microstrategy?

1032

What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.

990

What is data type of the surrogate key?

1001

What is the function of look up transformation?

1124

What is the difference between Open Connection command ang Open Session Command?

2445

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3574

What is workflow manager?

1050

Can you define set to be cardinality?

1012

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