Interested to Buy Any Domain ? << Click Here >> for more details...
On a day i load 10 rows in my target and on nextday i get 10
more rows to add in target. But out of 10 - 5 records are
send them to target?how i can insert the remaining records
- 1 Answers
- 3069 Views
- I also Faced
- E-Mail Answers
Answer Posted / nayek007
1. If stage table have some unique identifier then lookup wrt target table and skip the already inserted rows.
2. Use a flag in stage area..update that record when inserted into target table...and in sq filter the data set using that field.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is flashback table ? Advance thanks
Briefly define a session task?
COM components can be used in Informatica
How can we improve session performance in aggregator transformation?
Difference between Target-based loading and constraint-based loading?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Can informatica load heterogeneous targets from heterogeneous sources?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is domain in terms of informatica?
What are the new features of informatica 9.x at the developer level?
Quickly characterize reusable change?
