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 stages in datastage?
What is the difference between operational data stage (ods) and data warehouse?
What are the various kinds of the hash file?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are the steps needed to create a simple basic datastage job?
What is data partitioning?
Differentiate between datastage and informatica?
Triggers,VIEW,Procedures
what is the difference between == and eq in UNIX shell scripting?
How you can fix the truncated data error in datastage?
How rejected rows are managed in datastage?
What are the difference types of stages?
What is the difference between Datastage 7.5 and 7.0?
What all are the different way to run a job?
Define APT_CONFIG in Datastage?