col1
123
abc
234
def
jkl
768
opq
567
789
but i want two targetss target1 contains only numeric values
and target2 contains only alphabet values like
trg1
123
234
768
567
789
trg2
abc
def
jkl
opq
Answer Posted / prasad
hi shiva and srinu, its not work properly, would u plz
explain how to write the condition.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What steps should be taken to improve Datastage jobs?
What is difference between join, merge and lookup stage?
What is a quality stage in datastage tool?
What are some different alternative commands associated with "dsjob"?
What are the different types of lookups in datastage?
How to reverse the string using SQL?
How do you generate sequence number in datastage?
Why do we use link partitioner and link collector in datastage?
Define orabulk and bcp stages?
What is the difference between orabulk and bcp stages?
how to export or import the jobs in .ISX file
What is the purpose of pivot stage and types of containers in datastage
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
How do you import and export the datastage jobs?