suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping?how
- 4 Answers
- 9428 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / laksh
You can do this in one mapping by using sorter and then
expression transofrmation ..in Expression use 3 variables ..
1 Current 2 previous 3 route..
if prevous = current sent to table 2 else 1.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How do you load first and last records into target table?
How can we delete duplicate rows from flat files?
What is workflow? What are the components of the workflow manager?
What is workflow? What are the components of workflow manager?
What is mapping debugger?
How can you generate reports in informatica?
What can we do to improve the performance of informatica aggregator transformation?
What is a transaction control transformation?
What are the components of workflow manager?
How to load a Dimension ? and how to load a fact table?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
difference between repository database and repository service?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How do you load unique records into one target table and duplicate records into a different target table?
How to call shell scripts from informatica?
