How to load dimension and fact in same mapping at same
time.explain me the logic used for that scenario.
- 1 Answers
- 3161 Views
- IBM, I also Faced
- E-Mail Answers
Answer / 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 |
what is mystery dimension?
what is row level and column level indicator?
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
How Union Transformation is an Active Trans?
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
What is batch and describe about types of batches?
what is shortcut in informatica? difference between shortcut,reusable object?
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.
How can we improve session performance in aggregator transformation?
What are the differences between joiner transformation and source qualifier transformation?
How will you combine 3 different sources with a single source?
what is pre and post sql and what is diff between source presql and target pre sql
Teradata 
