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 |
complex mapping ur project u r invlve can u explain and give real time example give me ?
daily how much amount of data send to production?
Explain why we use partitioning the session in informatica?
How to eliminate duplicates from flat file..what is the procedure
How to load the source table into flat file target(with columns) in informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is expression transformation?
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
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.
How do we implement materialized view?when to use materialized view?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1