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 / eswar

this is not working plz explain clearly

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

why do u need the IOS upgradation in a FC switch

2339


Describe stream connector?

1360


How to reverse the string using SQL?

1597


client know skid info?

2137


Name the different types of Lookups in Datastage?

1313


What is "fatal error/rdbms code 3996" error?

1344


how many rows sorted in sort stage by default in server jobs

4052


How a source file is populated?

1115


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4240


Whats difference betweeen operational data stage (ods) and data warehouse?

1172


What are the types of containers?

1312


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2329


What are sequencers?

1173


Differentiate between Join, Merge and Lookup stage?

1143


How to read multiple files using a single datastage job if files have the same metadata?

1306