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 / 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 |
Post New Answer View All Answers
Why filter transformation is an active one?
What is a sorter transformation?
What is resilience time?
What is informatica? Why do we need it?
What is a pre-defined event and user-defined event?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
in reporting we add some new objects,how we get the count of the newly added objects to the report
What are the guidelines to be followed while using union transformation?
What are active transformations.
Have you worked with/created Parameter file
explain one complex mapping with logic? sales project?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is native users?
What is rank transformation?