Hi ETL gurus can any one tell me with a flow how to
implement SCD Type 1 and SCD Type 2 in a single mapping.For
some fields SCD type has to be implemented and for some
fields scd type has to be implementd..Thank in
advance..please let me know in case of any concerns...
Answer Posted / hemanth
yes, u can see the out put in single run,
in mappings tab one option is there, that is TARGET LOAD
ORDER.
yes we can do scd type1 and scd type2 in a single mapping
itself when the source is same for both. But with same
source we will never face that situation if so the changes
in source will reflect both scd1 and scd2.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is it possible to revert a global repository to local one and why?
What do you mean by channel change?
What is sq transformation?
In warehouses how many schemas are there?
What is status code in informatica?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How to delete duplicate row using informatica?
How to update a particular record in target with out running whole workflow?
Is there any target staging area in informatica not staging area
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is workflow manager?
Design a mapping to load a target table with the following values from the above source?
EXL informatica Questions
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?