Interested to Buy Any Domain ? << Click Here >> for more details...
source table have 3 records? and it is sucessfully loaded
into target. and 4more records is added in to source .that
means 7 records now in source. we have to load the
remaining 4 records into the same trgt table with maintian
top 3 records. how ?can any one give me the data flow of
this logic plz?
- 5 Answers
- 10742 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / kishore
Hi this will do by using INCREMENTAL LOADING.
We should delete records on staging area by using presql on
target(staging).
now staging having only new records..
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Plz can any one say me how to get the informatica certification materials and dumps
What is the different lookup cache(s)?
What are the components of Informatica? And what is the purpose of each?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is exclusive and normal mode for repository services?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
In informatica workflow manager, how many repositories can be created?
How you know when to use a static cache and dynamic cache in lookup transformation?
what is mean by complex business rule ?
What is a shortcut and copy in Informatica and how two are different with each other?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
