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?
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 are the different transaction levels available in transaction control transformation?
What is enterprise data warehousing?
How can we update a record in the target table without using update strategy?
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
How can we use batches?
What is transformation?
What are some examples of informatica etl programs?
How to generate sequence numbers?
Briefly define reusable transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
what is the size of your data warehousing?
What is mapping debugger?
Mention few advantages of router transformation over filter transformation.
How to Create a folder using pmrep command?
What is meant by pre and post session shell command?