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 5636

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

HCL,

9 29084

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 31493

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

1 12382

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

4 8593

what is data mapping

2 7957

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

2103

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 9451

Which type of joins Merge stage can support?

IBM,

7 17315

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

IBM,

2 18187

how can i test the reports in cognos

IBM,

1 5227

when can i use the STAR Schema and SNOWFLAKE Scgena

IBM,

4 10313

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

EDS,

2579

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

EDS,

2605

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

EDS,

2836

Un-Answered Questions { Data Warehouse }

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2765

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1847

Hi friends, what are the new features in abinito3.0?

2859

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4796

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2792

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2342

What is node? How many nodes and amps used in your previous project?

1173

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2257

How to create the source and target database connections in server manager?

1144

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2104

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3659

what are the names of the reports that you prepared?

1192

what are the dimensions that you have in your current project?list them?

2090

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2127

what are the data modeling tools you have used?(polaris)

2057

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