Interested to Buy Any Domain ? << Click Here >> for more details...
how to load duplicate row in a target
- 4 Answers
- 10165 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / amedela chandra sekhar
with out p.key in the target table we can load.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / swap
You can write UNION ALL query in source qualifier
eg:-select NAME,EMP_ID from EMPLOYEE
UNION ALL
SELECT NAME,EMP_ID FROM EMPLOYEE
| Is This Answer Correct ? | 0 Yes | 2 No |
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
Why we select the table which has minimum number of records as Master table in joiner?
what is size of u r database?
What are the types of lookup?
Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.
Under what condition selecting sorted input in aggregator may fail the session?
how to identify new and old values in source qualifier or any other transformations using informatica
How to load time dimension?
What is sorter transformation?
How to run a session, which contains mapplet?
What are Dimensions and various types of Dimensions?
Teradata 
