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

You can ask about - meta pivot, leading records, read & write multiple files component ? How to use in abinitio graph?

IBM, TCL,

1 7666

What is meta programming ? Can you generate xfr dynamically? How to use in abinitio graph?

IBM, TCL,

1 24113

How you can delete an object from EME data store ? How to use in abinitio graph?

IBM, TCL,

1 12099

How you can delete an object from a tag ? How to use in abinitio graph?

IBM, TCL,

1 12503

If you check in one file twice in EME, one with a tag and second without a tag - Will the version number change ? How to use in abinitio graph?

IBM, TCL,

2 8683

What is use of creating a save files? How to use in abinitio graph?

Cognizant, IBM, Intellego, TCL,

1 13988

What is air-project parameter ? How to use in abinitio graph?

IBM, TCL, Tech Mahindra,

3 16961

6) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f) FIRST.BY VARIABLE g) LAST.BY VARIABLE h) _NAME_ i) _TYPE_ j) _FREQ_ k) _STAT_ l) _BREAK

IBM, SAS,

1 5642

In one of my report i have one data item sales_amount. If this report is run by one user from india so the sales_amount should be display in indian repees(Rs.) format, if USA user then in dollers($), if UK user then In Pounds.Hou can i achive this? Please answer me.

Accenture, HCL, IBM,

4 9197

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1721

If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

TCS,

2 5368

in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh

IBM,

1 4298

in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5

IBM, YCS,

3 6799

what is difference between scd2 and scd3

3 9776

i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.

Wipro,

4 8300

Un-Answered Questions { Data Warehouse }

What is freehand sql?

1054

Difference between Data and Index Caches?

1141

Can we collect statistics on table level?

1036

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1131

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3797

Explain what are components of reportnet?

975

What is difference between content store and content manager?

983

What is bteq script in teradata?

1158

client know skid info?

2086

What is the difference between olap and datawarehosue?

957

how would you determine the number of missing or nonmissing values in computations? : Sas programming

1157

What do you mean by the term data warehousing? Is it different from data mining?

1219

How we can create indexes after completing the loan process?

1211

What is factor analysis?

1139

How are models actually derived?

2011

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