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
How to improve the performance of a session using sorter transformation?
What is sequence generator transformation in informatica?
What is union transformation?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Enlist the various types of transformations.
Quickly characterize reusable change?
Target increases every day even though no new record was inserted
How can we store previous session logs?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Differentiate between reusable transformation and mapplet.
in reporting we add some new objects,how we get the count of the newly added objects to the report
How to create or import flat file definition in to the warehouse designer?
What is transformation?