Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nagaraju bhatraju
take a lookup on t1 and look for dupliates in exp and
collect duplicate values to t2
or
you can hold preveious key value in variable port and can
compare it with new coming value , and you can flag these
rec as duplicate rec if both are matched , i mean previous
and current key, sorter should be used before exp as key
values should be come in sorted order only
(This technique is called forward referencing )
( Note : in other senarios if require you can use self
reference also basing on our requirements )
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How many dimensions are there in informatica?
Performance tuning in UNIX for informatica mappings?
What is the benefit of partitioning a session?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
waht type of interface is used for testing the data in informatica
What is the difference between STOP and ABORT options in Workflow Monitor?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Explain constraint based loading in informatica
What is session task and command task?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How many transformations can be used in mapplets.
hi real timers . iam waiting for ur reply regarding ETL TESTING
How to use pmcmd utility command?
