How or for what purpose look up transformation would be
useful in Sales or Banking Project?
Please reply!
Answers were Sorted based on User's Feedback
Answer / raj
For maintaining the complete history we need to look up on
the target table especially in sales and banking projects we
use SCD2 type mappings for maintain the complete history.
Is This Answer Correct ? | 1 Yes | 0 No |
Thankd for your reply.
Could you please explain me about transaction code?
Is This Answer Correct ? | 0 Yes | 0 No |
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
how can u avoid duplicate rows in flat file?
What are the measure objects?
What is polling?
hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.
What is a candidate key?
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
What are the reusable transforamtions?
where to store informatica rejected data?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?