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

How do you load dimension data and fact data? Which is first

Question Posted / kiran

Answers were Sorted based on User's Feedback



How do you load dimension data and fact data? Which is first..

Answer / usha

first we load data into dimension table then we will loadin
to fact table..

dimensions and facts has parent and child relationship.

many to one relation

Is This Answer Correct ?    9 Yes 1 No

How do you load dimension data and fact data? Which is first..

Answer / manikandan

1.First load the data in to Dimension tables from the
sourse table

2.Load the data into fact table from source by putting
lookup on to
the dimension tables (If it is a fact less fact table U
need to load
only dimension data other wise load the messers from source
also)

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Data Stage Interview Questions

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

0 Answers  

Tell me Wt main advantage of Stage varibles? Project level hints?

4 Answers   Hexaware,

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

0 Answers  

Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.

4 Answers   iGate, Thirdware,

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?

15 Answers   Scope International,




What is PX?

2 Answers   IBM,

what is materialized view used datastage?

1 Answers   HSBC,

How many types of hash files are there?

0 Answers  

What is the difference between account and directory options ?

0 Answers  

What is the difference between operational data stage (ods) and data warehouse?

0 Answers  

What is ibm datastage flow designer?

0 Answers  

Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers   Accenture,

For more Data Stage Interview Questions Click Here
Categories