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
Explain pmcmd command usage in informatica
How big was your fact table
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What are the databases that informatica can connect to windows?
What are the designer tools for creating transformations?
What are pre and post-session shell commands?
What is meant by incremental aggregation?
How can repository reports be accessed without sql or other transformations?
What is domain in terms of informatica?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Differentiate between sessions and batches?
What all join we can perform in LOOKUP transformation?
What are session parameters ? How do you set them?
How many numbers of sessions can one group in batches?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?