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
- 10745 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
What do you mean by enterprise data warehousing?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are different types of transformations available in informatica?
How can you increase the performance in joiner transformation?
What is data caches/ index caches?
What does reusable transformation mean?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is a repository manager?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is a connected transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What are the conditions needed to improve the performance of informatica aggregator transformation?
Tell me about Propagate functions in informatica
Where is metadata stored?
