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
What are the types of schemas we have in data warehouse and what are the difference between them?
What are the informatica performance improvement tips
scenario where i can use only concurrent execution of workflow.
what is SDLC way of code development?
complex mapping ur project u r invlve can u explain and give real time example give me ?
I have a flat file, want to reverse the contents of the flat file
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?
What are the databases that informatica can connect to windows?
Explain joiner transformation in informatica
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How many ways are there to create ports?
How to generate sequence numbers using expression transformation?
Why update strategy and union transformations are active?
How do you load first and last records into target table?
What do mean by local and global repository?