I have a source table with column name CITY having 100
records,
I want target table with column name start with 'A'
and 'B',remaining columns as reject outputs.
how can achieve this by data stage?please help me?????
Answer Posted / koti
seq---tx----target1
|
|
target2
In Transformer use below constraint for target1.txt
UpCase(DSLink3.Field001) [1,1]= "A" Or UpCase(DSLink3.Field001) [1,1] = "B"
In Transformer use below constraint for target2.txt
tick on otherwise/log
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
How can you write parallel routines in datastage PX?
What is the method of removing duplicates, without the remove duplicate stage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Nls stands for what in datastage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What are constraints and derivations?
What is the process of killing a job in datastage?
Differentiate between operational datastage (ods) and data warehouse?
how to add a new records into source?
How and where you used hash file?
What are some prerequisites for datastage?
What is datastage engine?
What are orabulk and bcp stages?
What is the difference between Datastage 7.5 and 7.0?