How to load dimension and fact in same mapping at same
time.explain me the logic used for that scenario.
Answer Posted / isha
We can use contraint based loading in that case and after loading all the dimensions table we can load the data into fact table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are junk dimensions?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is rank transformation in informatica
How do we call shell scripts from informatica?
Briefly describe lookup transformation?
Explain the shared cache and re-cache?
What is a stored procedure transformation?
Why union transformation is an active transformation?
Differences between connected and unconnected lookup?
What is a surrogate key?
Define update strategy?
What are the differences between a connected lookup and unconnected lookup?
draw informatica architecture 8.6 ?
What is meant by pre and post session shell command?