How do you load dimension data and fact data? Which is first
- 2 Answers
- 14386 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
how to add a new records into source?
What is the precedence of stage variables,derivations, and constraints?
what is the custome stage in datastage? how can we impliment that one? plz tell me
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What all the types of jobs you developed?
What are the different plug-ins stages used in your projects?
what is the difference between == and eq in UNIX shell scripting?
What is aggtorec restructure operator?
If you want to use a same piece of code in different jobs, how will you achieve this?
What are the important features of datastage?
What are the partitioning techniques available in link partitioner?
How a server job can be converted to a parallel job?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Can you highlight the main features of ibm infosphere information server?
whom do you report?
