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
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 |
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
What do you mean by worklet?
Performance wise which is better joiner or look up ? Give me with example?
normalizer transformation
how to import multiple flat files in to single target where there is no common column in the flat files
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
what happens if you try to create a shortcut to a non- shared folder?
What is hash partition?
What are teh different tasks that can be created in workflow manager?
Under what condition selecting sorted input in aggregator may fail the session?
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?