Answer Posted / vignesh muralidharan
Type1: No historical datas will be available, when changes
are made the old data will be deleted and the new data will
be insrted.
Type2: Flag:The old data will be denoted as false and the
new data will be denoted as true.
Version:The changes made will be numbered as 0,1,2...so on.
Date:The changes along with the date in which they are made
are clearly mentioned.
Type3:The latest change which is made is alone available.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Explain the mapping variable usage example in informatica
Which transformation is needed while using the Cobol sources as source definitions?
Briefly define reusable transformation?
what is the difference between informatica6.1 and infomatica7.1
What are pre and post-session shell commands?
Different qualification between a related rotate toward the sky and isolates look upward?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How might one distinguish in the case of mapping is right or not without associating session?
how many types of dimensions are available in informatica?
What is the function of look up transformation?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
What is the reusable transformation?
How to create or import flat file definition in to the warehouse designer?