Interested to Buy Any Domain ? << Click Here >> for more details...
how to load duplicate row in a target
- 4 Answers
- 10310 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 |
What is option by which we can run all the sessions in a batch simultaneously?
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
How You Pull the records on daily basis into your ETL Server.
what is threshold error in informatica?
Write the unconnected lookup syntax?
Different qualification between a related rotate toward the sky and isolates look upward?
how lookup is acting as both active and passive ? how is it possitble?
diffrence between command task and control task
Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com
What is the difference between STOP and ABORT options in Workflow Monitor?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
In ur current projectu have done any performance tuning of mappings?
Teradata 
