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
- 10986 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 is the different lookup cache(s)?
What are the limitations of joiner transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is informatica worklet?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are mapplets? How is it different from a Reusable Transformation?
How to generate sequence numbers using expression transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are the restrictions of union transformation?
What do you mean by enterprise data warehousing?
What are the new features of Power Center 5.0?
explain one complex mapping with logic? sales project?
