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

How to identify in report that is apply as a detail or summary filter?By looking the report have to identify the report has applied as detail or summary filter to that report?

Mind Tree,

1 5555

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?

HCL,

9 28645

I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..

Cognizant, IBM, TCS, Virtusa,

9 31043

If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).

1 12268

How to eliminate duplicates from flat file..what is the procedure

4 8357

what is data mapping

2 7814

hi, I want to create this report... List View--- -(Drop down list) Order Date From: \/ To: Customer Employee Order customer ------------------------------------------------------------ ------------------------------------------------------------ ------ customer c-name c-address c-phone c- city.................... ------------------------------------------------------------ ------------------------------------------------------------ ----- c-id c-type . . . ------------------------------------------------------------ ------------------------------------------------------------ ---- Employee .............same like one list Order.....................same like one list These are all in one page....i want u show... condtions *when i select in view type ex:employee and date as 10-05- 2007 to 10-05-2010 I need to go the employee list table and display the items .. And Iam trying in value prompt for creating of (cust,emp,ord)in a single value prompt,that will not created... and how to create 3-list and connection for those in value prompt.. Pls any one knows explain me (by step by step) of creating that report? Thanks Vannur

2036

Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

IBM,

4 9227

Which type of joins Merge stage can support?

IBM,

7 17007

How to load the data from an excel sheet to input file in a graph?

IBM,

2 18023

how can i test the reports in cognos

IBM,

1 5117

when can i use the STAR Schema and SNOWFLAKE Scgena

IBM,

4 10084

1.What is a delta record? How you will read it? 2.What are the different types of sorting?

EDS,

2514

1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?

EDS,

2540

What is a delta record? How you will read it?

EDS,

2741

Un-Answered Questions { Data Warehouse }

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1628

What are the various methods of getting incremental records or delta records from the source systems?

930

What is domain in terms of informatica?

1007

What are the possible data marts in retail sales?

996

Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

2236

what is the custome stage in datastage? how can we impliment that one? plz tell me

2367

What is report as filter in microstrategy?

917

Compare etl & elt?

1012

How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

1674

What is sort component in abinitio?

1222

Name the various types of filters?

947

What is index awareness in universe?

1034

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1058

Highlight the need for Performance Tuning.

1103

Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

1130

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