Interested to Buy Any Domain ? << Click Here >> for more details...
how to load duplicate row in a target
- 4 Answers
- 10223 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 we r using aggregator we enabled sorted input but the records r not sorted what happen?
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
What are set operators in Oracle
why union is active transformation?
What are the prerequisite tasks to achieve the session partition?
What are events in workflow manager?
why u go for dimensions ?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to do unit testing in informatica? How to load data in informatica ?
Explain joiner transformation in informatica
What is joiner transformation?
Teradata 
