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
- 10968 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
Write the different tools in the workflow manager?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Where are the source flat files kept before running the session?
my source is junk data how will u remove that junk data by using unix please any one replay me
Explain incremental aggregation in informatica
What is persistent lookup cache?
Explain the difference between mapping parameter and mapping variable?
How can we delete duplicate rows from flat files?
What is a connected transformation?
How to load data in informatica ?
Mention some types of transformation?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How are indexes created after completing the load process?
How do you load unique records into one target table and duplicate records into a different target table?
Differentiate between sessions and batches?
