Interested to Buy Any Domain ? << Click Here >> for more details...
How do you load dimension data and fact data? Which is first
- 2 Answers
- 15283 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
How can we improve performance of data stage jobs?
how can we send even and odd records from a sequential file to two different targets
10 Answers IBM, iGate, TCS,
Define Data Stage?
How the ipc stage work?
how to add a new records into source?
Differentiate between operational datastage (ods) and data warehouse?
I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
how can or from where we can get reference data in scd type2 implementation?
deptno wise to find max and min,and sum of rows and in target to company wise maximum
What is the command line function to import and export the ds jobs?
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
Teradata 
