How to load dimension and fact in same mapping at same
time.explain me the logic used for that scenario.
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 |
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Why we use stored procedure transformation?
What are the types of schemas we have in data warehouse.
What is difference between partioning of relatonal target and partitioning of file targets?
Describe the impact of several join conditions and join order in a joiner transformation?
How to call stored Procedure from Workflow monitor in Informatica 7.1 version?
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
What is the use of transformation?
What are partitions in informatica and which one is used for better performance?
What is the sequence generator transformation in informatica?
What you know about transaction control transformation?
Explain sessions?