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 is the difference between == and eq in UNIX shell scripting?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What are the different options associated with dsjob command?
What is the difference between in process and inter process?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What are the various kinds of containers available in datastage?
client know skid info?
CHANGE CAPTURE
Explain the importance of surrogate key in data warehousing?
Can you filter data in hashed file?
What are the different types of lookups in datastage?
What is "fatal error/rdbms code 3996" error?
What is the project in datastage?
what is the use of surogate key in datastage
Differentiate between validated and Compiled in the Datastage?