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 usage analysis in datastage?
options available in sequence job to run,validate?
How do you schedule or monitoring the job?
Define orabulk and bcp stages?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Where the datastage stored his repository?
Describe link sort?
Describe routines in datastage? Enlist various types of routines.
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What are the processing stages?
What are routines in datastage?
what is flow of project?
What is the sortmerge collector?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?