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


Please Help Members By Posting Answers For Below Questions

What are the different common services in datastage?

705


What is the process of killing a job in datastage?

590


What could be a data source system?

577


what is the difference between == and eq in UNIX shell scripting?

972


Why fact table is in normal form?

673






Differentiate between hash file and sequential file?

579


Explain entity, attribute and relationship in datastage?

635


Differentiate between datastage and informatica?

725


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

1919


Where do you see different stages in the designer?

629


client know skid info?

1633


Terminate Activity

839


what are the errors,warnings in datastage

2149


Differentiate between validated and Compiled in the Datastage?

642


How do you start developing a datastage project?

660