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
- 3503 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
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How do you migrate data from one environment to another?
What is workflow manager?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Why filter transformation is an active one?
How will the document be delivered to me?
What is parallel processing in informatica?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is the need of an ETL tool?
How you can differentiate between connected lookup and unconnected lookup?
How to do unit testing in informatica? How to load data in informatica ?
Differentiate between a database and data warehouse?
Explain the scenario which compels informatica server to reject files?
What is union transformation in informatica?
What are the components of the workflow manager?
