If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING..
CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE
RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
Answer / babu
yes, u can see the out put in single run,
in mappings tab one option is there, that is TARGET LOAD
ORDER.
if any thing is wrong please let me know.
Cheers,
babu
| Is This Answer Correct ? | 5 Yes | 0 No |
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
What are the Differences between static cache and dynamic cache?
What is meant by query override?
what is the logic will you implement to load data into a fact table from n dimension tables?
How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
What is the procedure for creating independent data marts from informatica 7.1?
If we set dd_insert in mapping and Delete in session properties what will happen.?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani
what are the Methods For Creating Reusable Transformations?
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size