how to load duplicate row in a target
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 |
What are data-driven sessions?
what is persistant cache in which situation we will use persistantcache
What is difference macros and prompts?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How to do unit testing in informatica?
What are the circumstances that infromatica server results an unreciverable session?
without dynamic lookup transformation how to insert new rows and update existing rows?
How can you differentiate between powercenter and power map?
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
Differentiate between joiner and lookup transformation?
How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica