source
1123445
I WANT OUTPUT AS
DUPLICATES TO TARGET1 LIKE
TARGET1
1144
NON-DUPLICATES TO TARGET2
TARGET2
235
Answer Posted / shreeram
Seq(source)------> Transform stage-------> Tgt1
!.........>Tgt2
use substring in transform stage.
Is This Answer Correct ? | 0 Yes | 11 No |
Post New Answer View All Answers
What are the different common services in datastage?
What is the process of killing a job in datastage?
What could be a data source system?
what is the difference between == and eq in UNIX shell scripting?
Why fact table is in normal form?
Differentiate between hash file and sequential file?
Explain entity, attribute and relationship in datastage?
Differentiate between datastage and informatica?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Where do you see different stages in the designer?
client know skid info?
Terminate Activity
what are the errors,warnings in datastage
Differentiate between validated and Compiled in the Datastage?
How do you start developing a datastage project?