CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING?
IF SO HOW?
Answer Posted / gunnala
Yes, we can implement slowly changing dimensions concept with Type1 and Type2, provided we need to have same source and knowledge of how to use mapplet designer
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Design a mapping to load a target table with the following values from the above source?
Write the advantages of partitioning a session?
How can you increase the performance in joiner transformation?
Explain the etl program with few examples.
Can we override a native sql query within informatica?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is the use of transformation?
How to generate sequence numbers?
What are the informatica performance improvement tips
Describe the impact of several join conditions and join order in a joiner transformation?
How to update source definition?
How can repository reports be accessed without sql or other transformations?
What the difference is between a database, a data warehouse and a data mart?