Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2820


What steps should be taken to improve Datastage jobs?

1003


What is difference between join, merge and lookup stage?

1039


What is a quality stage in datastage tool?

1023


What are some different alternative commands associated with "dsjob"?

1080


What are the different types of lookups in datastage?

1006


How to reverse the string using SQL?

1425


How do you generate sequence number in datastage?

1025


Why do we use link partitioner and link collector in datastage?

1076


Define orabulk and bcp stages?

1067


What is the difference between orabulk and bcp stages?

967


how to export or import the jobs in .ISX file

1132


What is the purpose of pivot stage and types of containers in datastage

996


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

1504


How do you import and export the datastage jobs?

1109