Interested to Buy Any Domain ? << Click Here >> for more details...
How to load dimension and fact in same mapping at same
time.explain me the logic used for that scenario.
- 1 Answers
- 3426 Views
- IBM, I also Faced
- E-Mail Answers
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
During the running session, output files are created by informatica server. Enlist few of them.
What is mapping debugger?
What do mean by local and global repository?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is complex mapping?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is lookup change?
Can informatica load heterogeneous targets from heterogeneous sources?
How to join three sources using joiner? Explain though mapping flow.
What are session parameters ? How do you set them?
How many transformations can be used in mapplets.
can we override a native sql query within informatica? How do we do it?
Explain transaction control transformation in informatica
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the differences between oltp and olap?
