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
- 10906 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / ap
Use the target table as lookup and check for the existance
of the rows from source in the lookup. If the row already
exists then ignore and only pass the new rows to the target.
| Is This Answer Correct ? | 18 Yes | 3 No |
Post New Answer View All Answers
Mention few advantages of router transformation over filter transformation.
Explain constraint based loading in informatica
What is aggregate cache in aggregator transformation?
What is a code page?
Define the various join types of joiner transformation?
What the difference is between a database, a data warehouse and a data mart?
Can we create a Integration service without a Repository service and vice versa?
Different qualification between a related rotate toward the sky and isolates look upward?
What are data-driven sessions?
What is the sequence generator transformation in informatica?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is the benefit of partitioning a session?
Why do you use Mapping Parameter and mapping variable?
What are the prerequisite tasks to achieve the session partition?
Whats the difference between informatica powercenter server, repositoryserver and repository?
