how can send duplicate records to one tableand non
duplicate records to one table with simple clear mapping?
Answers were Sorted based on User's Feedback
Answer / sivananda reddy
In informatica use this mapping
source->sqr->aggr->router->exp->target1
|
|->exp->target2
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / roshan
hey u have to write a stored procedure to compare each record and then use a router T/R, if the record is non duplicated then it sends to one target and duplicated records to another target.. hope it works..
let me know if better option is available..
infernonag@gmail.com
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / rajan raorane
You can use Router where One update strategy is directy
connected to Target table while other update strategy must
be followed by sorter with DISTINCT check which shud be
further connected to target table
This will differntiate Duplicate and non-duplicate records
in target table
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gopi
For this i have seen one excellent video in YOUTUBE. Please
check this site.
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / radhakrishnansk
Considering the source as flat file.
src-->Src qual ---> sorted transfomation -->trgt
|
|---> trgt
In sorted transformation, we can choose distict in
properties. So the duplicate is avoided.
correct me if I am wrong
Is This Answer Correct ? | 1 Yes | 11 No |
wat are deployement groups in informatica, how it will be used for developers
What is the capacity of power cube?
if soource is having 10 records how will u insert 20 records to target
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
What is a snowflake schema?
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
Define informatica repository?
What are the different types of transformation available in informatica.