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 7667

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 8685

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 16963

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 5643

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

1722

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 6800

what is difference between scd2 and scd3

3 9778

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 are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?

1100

define cognos connection?

Differences between where and if statement?

1096

What are the types of data processing you are familiar with?

1218

What is datastage?

1088

What are non-additive facts in detail?

995

Enlist the advantages of informatica.

1069

After the complete generation of a report who will test the report and who will analyze it?

984

What is a passive transformation?

1106

How to define a cube??

936

what is the complex transformation you used in informatica

2589

How can we use external procedural logic in informatica?

925

plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........

2354

What is thumbnail?

975

if collect stats but it show low confidence why?

1691

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