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
- 13218 Views
- I also Faced
- E-Mail Answers
Answer Posted / animesh
I think what u can do is u can create a mapping by using
mapping wizard and apply SCD 2 as in SCD u can get historic
data while in SCD one u can onlly get the latest data.
create a mapping using SCD 2
Give the source and target tables.
Give the fields on which u want to implement the history
logic and then just complete the wizard.
the mapping will be created which will have 3 Update
strategy transformation which is basically one for insert
only flow, one for insert and update flow. and one for
insert and update flow also the previous records available.
The other transformations presented in mapping are in the
below manner.
Source --->> SQ --->>> Seq Gen --->>>> Lookup (For target
table lookup)--->>>>> Update Strg (3 nos) ---- >>>> Exp
Tr ---->>>>>> Target table.
Hope this will give you the clear understanding. guys
please correct me if i missed some thing.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the components of workflow manager?
How we can create indexes after completing the load process?
What are the different types of olap? Give an example?
Describe expression transformation?
What are mapplets? How is it different from a Reusable Transformation?
whats the logic to load the lower level of granularity of data to fact table.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Define filter transformation?
Which is the t/r that builts only single cache memory?
When do you use sql override in a lookup transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
Can anyone tell me the new features in Informatica 9 Version?
How can one identify whether mapping is correct or not without connecting session?
What is aggregator transformation in informatica?
How are indexes created after completing the load process?
