Interested to Buy Any Domain ? << Click Here >> for more details...
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?????
- 5 Answers
- 12511 Views
- I also Faced
- E-Mail Answers
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
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What are the processing stages?
What is the difference between in process and inter process?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is job control?
Can you explain link buffering?
What is the difference between orabulk and bcp stages?
How to reverse the string using unix?
Where do you see different stages in the designer?
What is datastage engine?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Different ways a project can be moved to production ?...example ….export-import and Version control.
what are the devoleper roles in real time? plz tell i am new to datastage....
What is usage analysis in datastage?
