Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 13167 Views
- iGate, I also Faced
- E-Mail Answers
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 is size of u r database?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Target increases every day even though no new record was inserted
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
4 yrs etl devloper roles and responsibilities?any body give solutions
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How can we use mapping variables in informatica? Where do we use them?
What is meant by query override?
What is joiner transformation in informatica?
What is Session and Batches?
What is the difference between informatica 7.0 and 8.0?
How can you define user defied event?
what is informatica metadata?
