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?????
Answers were Sorted based on User's Feedback
Answer / bg
Job design will be:
seq --- Tx ---- target.txt
|_____ reject.txt
IN transformer use below constraint for target.txt
Left(city,1)='A' or Left(city,1)='B'
Check the otherwise and send it to reject file.
Is This Answer Correct ? | 22 Yes | 0 No |
Answer / satish
Job design will be:
seq --- Tx ---- target.txt
------rejct.txt
IN transformer use below constraint for target.txt
Left(city,1)='A' or Left(city,1)='B'
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / naresh
Hi,
sequential-----filter------ds
in filter stage
where clause= city like 'A%' OR CITY LIKE 'B%'
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / rajesh reganti
Job design will be:
seq --- Tx ---- target.txt
------rejct.txt
IN transformer use below constraint for target.txt
City[1,1] = 'A' or City[1,1] = 'B'
IN transformer use below constraint for reject.txt
otherwise
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
how many dimentions and fact tables used in your project and what are names of it?
Difference between server jobs & parallel jobs?
What are the types of hashed files in data stage
how will u design file watch jobs?
how can we join one oracle & flat files ?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.
What is ds designer?
how to create document in datastage?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How to convert RGB Value to Hexadecimal values in datastage?
What is a datastage job?