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
What the difference is between a database, a data warehouse and a data mart?
What is a sorter transformation?
Separate from a database, an information bazaar, and an information stockroom?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain sessions?
Explain lookup transformation source types in informatica
How do you update the records with or without using update strategy?
can we override a native sql query within informatica? Where do we do it? How do we do it?
According to his methodology what all you need before you build a datawarehouse
How can we update a record in the target table without using update strategy?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How many input parameters can exist in an unconnected lookup?
What is informatica powercenter repository?
How can we remove the duplicates from flat file source?
What is the cumulative sum and moving sum?