i want to load data in to two targets..one is dimension
table and the other is fact table?how can i load ata a time
- 3 Answers
- 11909 Views
- iGate, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / john
Generally we all knew that is,In Datawarehouse
environment,we should load data first in the dimension
table then we load into the fact table..bcoz fact table
which contains the Primary keys of the dimension table
along with the measures.
So we need to check first that whether the fact table which
you are going to load that has foreign key relationship
with the dimension table or not?If yes,Use pipeline mapping,
and load dimension data first in first pipeline and in the
second pipeline load fact table data by taking the lookup
transformation on the dimension table which has loaded data
already..and return the key value from the lookup
transformation then calculate the measures by using
Aggregator and also give "group by" on the dimension keys
and map to the Target(Fact) prots as required.
most importantly specify the "Target Load Plan"
where dimesion target as first,fact table target as second.
let me pls correct my answer If i am wrong..
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / g. manthiramoorthy
Using dynamic lookup, you can load both simultaneously.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / amedela chandra sekhar
use surrogate pipeline technique first data loaded into dimension table ,then loaded into fact fable with primary and foreign key technique b/w dimension and fact table.
use lookup t/r.........
| Is This Answer Correct ? | 2 Yes | 0 No |
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
Limitation of REPLACESTR. Is there any character limitation to it.
What is the main difference between a Joiner Transformation and Union Transformation?
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
what is Active lock explain
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
what is diff b/t sorter t/r and agg have the option sorter property...
Implementation methodology
what is upstream and downstream transformation?
Quickly characterize reusable change?
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Teradata 
