Interested to Buy Any Domain ? << Click Here >> for more details...
On a day, I load 10 rows in my target and on next day if I
get 10 more rows to be added to my target out of which 5 are
updated rows how can I send them to target? How can I insert
and update the record?
- 6 Answers
- 13439 Views
- I also Faced
- E-Mail Answers
Answer Posted / sasi
the best way to do this use the slowy changing dimension in
the mappings-->wizzard-->slowly changing dimension-->type1
here u need to select the source and target tables.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What are the new features of informatica 9.x developer?
What is parallel processing in informatica?
State the limitations where we cannot use joiner in the mapping pipeline?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
which one is better performance wise joiner or look up
How to use procedural logic inside infromatica?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Explain lookup transformation source types in informatica
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What are the types of schemas we have in data warehouse and what are the difference between them?
Do you find any difficulty while working with flat files as source and target?
Briefly define reusable transformation?
Can we create a Integration service without a Repository service and vice versa?
What does refresh system mean, and what are its distinctive choice?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
