Seq(source)------> Transform stage-------> Tgt1

source
1123445
I WANT OUTPUT AS
DUPLICATES TO TARGET1 LIKE
TARGET1
1144
NON-DUPLICATES TO TARGET2
TARGET2
235

Question Posted / shreeram

Answer Posted / shreeram

Seq(source)------> Transform stage-------> Tgt1
!.........>Tgt2

use substring in transform stage.

Is This Answer Correct ?

0 Yes

11 No

Please Help Members By Posting Answers For Below Questions

Explain entity, attribute and relationship in datastage?

1155

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3852

What is the difference between in process and inter process?

1203

Distinguish between informatica & datastage. Which one would you choose and why?

1043

Give an idea of system variables.

1090

What is quality stage?

1044

What can we do with datastage director?

1292

Difference between sequential file and data set?

1261

Define ds designer?

1328

How to convert RGB Value to Hexadecimal values in datastage?

4057

What are the enhancements made in datastage 7.5 compare with 7.0?

1208

What is size of a transaction and an array means in a datastage?

1366

What is the precedence of stage variables,derivations, and constraints?

1126

What is the difference between server job and parallel jobs?

1200

What are the benefits of datastage?

1301