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
Answer Posted / 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 |
Post New Answer View All Answers
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
State the differences between sql override and lookup override?
How to generate sequence numbers without using the sequence generator transformation?
explain abt ur project architecture?
How do you convert single row from source into three rows into target?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Is it possible to use a client with different version than that of its Informatica server?
difference between informatica 8.1.1 and 8.6
What are the advantages of using informatica as an etl tool over teradata?
Write the different tools in the workflow manager?
What are the measure objects?
What is rank transform?
What is complex mapping?
where to store informatica rejected data?
How do you use reject loader.