1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

IBM,

1 4412

What is diff between connected and unconnected lookup?

BirlaSoft, Blue Star Infotech,

5 7207

What is diff joiner and lookup

BirlaSoft,

4 7180

what is mapping parameter and mapping variables

BirlaSoft,

1 4289

if i am having 10 records in source, i want 20 records in target...how will you do it

BirlaSoft, IBM,

13 15081

without matching columns in two tables. how can you join

BirlaSoft,

5 9689

how to call lookup qualifer in unconnected look;up

BirlaSoft,

1 4881

What is differnce between Error code and Error Level in Bteq

IBM,

6 36749

Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table

IBM,

6 18965

can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com

IBM,

4 6871

How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step

 1 7065

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

 2124

what is crosstab space

IBM,

1 12771

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

Span Systems,

5 6654

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

Span Systems,

3 4974

Un-Answered Questions { Data Warehouse }

What is microstrategy?

566

Can you define report item?

582

What are sequencers?

604

When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?

654

Explain scan md?

561




what is song in infrmatica...?

1660

Name the different type of processing based on the steps that you know about?

604

Under what conditions selecting sorted input in aggregator will still not boost session performance?

620

What are global filter and how they differ from column filter?

523

Give some information on report bursting?

556

This entry was posted in General. Bookmark the permalink. Post a comment or leave

4000

What is the difference between teradata and basic rdbms?

556

What is MAX CORE of a component?

695

How do we design a universe?

510

what is the function of catx syntax? : Sas-administrator

632

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