Hi 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....
Answer / kiran ghatage
You will find this in following examples...
https://community.informatica.com/solutions/mapping_implementing_scd1_using_md5
https://community.informatica.com/solutions/mapping_scd_type_2_effective_date
https://community.informatica.com/solutions/mapping_scd_type_2_versioning
| Is This Answer Correct ? | 0 Yes | 0 No |
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
What is CHECK-IN CHECK-OUT. Please explane me?
What are the components of the workflow manager?
Is it possible to define a single node as a Gateway node as well as worker node?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is mapplet in informatica?
Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.
insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files
How can you generate reports in informatica?
What are active and passive transformations?
If we have lookup table in workflow how do you trouble shhot to increase performance?
In a table, 4 person having same salary. How to get Third person record only?