How do you load dimension data and fact data? Which is first
- 2 Answers
- 14352 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Define Routines and their types?
What are the components of datastage?
What is a quality stage in datastage tool?
How a routine is called in datastage job?
Does datastage support slowly changing dimensions ?
Can you highlight the main features of ibm infosphere information server?
What are the different types of lookups in datastage?
How to clean the datastage repository?
How do you remove duplicate values in datastage?
How to read the length of word in unix?
What can we do with datastage director?
how to implement scd2 in datastage 7.5 with lookup stage
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Can we use target hash file as a lookup ?
