Interested to Buy Any Domain ? << Click Here >> for more details...
How to extract original records at one target & Duplicate
records at one target?
- 12 Answers
- 21789 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rag
Hi You can do this another way also
put the expresession transforamtion and read some previous
record with the currect record or any unique column value in
the expression and if they are equal then assign the
flag(means duplicate flag) else
assign the new flage.
pass the duplicate flag records to the filter and goes to
the TB(duplicate records target) and unique values to the
origonal target
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / saradhi
As of my knowledge i think its possible by Router
Transformation.By writing one condition we can extract the
data with out duplication in one target then automatically
default records means with duplication are transferred in
to another target.
| Is This Answer Correct ? | 0 Yes | 5 No |
what is the mechanism of the Master-Detail joining condition?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
Hi experts, can anyone tell how much we use plsql in real time
Which kind of index is preferred in DWH?
How to update source definition?
what are surrogate keys?
what is datamart
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
how to load only the first and last record of a flat file into the target?
Differnce between filter and router?
Teradata 
