CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING?
IF SO HOW?
Answer Posted / ankit kansal
yes we can achieve both scd1 and scd2 with in the same mapping in informatica just router to define the flow and use update strategies as per the required logic...
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
in reporting we add some new objects,how we get the count of the newly added objects to the report
What are data-driven sessions?
What is a node in Informatica?
What are the components of workflow manager?
What is a stored procedure transformation?
On which transformations you created partitions in your project?
Different sorts of metadata that stores in the storage facility?
What if the source is a flat-file?
lookup transformation with screenshots
How many number of sessions can one group in batches?
How to elaborate tracing level?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is complex mapping?
Describe expression transformation?