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
- 22347 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 |
Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com
What is a poling?
what is mystery dimension?
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
what are the unix commands to start the wrk flow ?
What is update strategy transform?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
What is rank transformation?
How do you load unique records into one target table and duplicate records into a different target table?
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc
Explain lookup transformation is active in informatica
What is a taget load order?
Teradata 
