1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / kiran

Answer Posted / kiran

By using transformer stage we can implement this
in transofrmaer functions like alfa funcation
and numric functions these functions are using to
implement this

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is size of a transaction and an array means in a datastage?

863

Difference between in process and inter process?

780

What are system variables and sequencers in datastage

693

why do u need the IOS upgradation in a FC switch

1959

Define Merge?

984




WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3350

Is the value of staging variable stored temporarily or permanently?

671

What are the enhancements made in datastage 7.5 compare with 7.0?

803

CHANGE CAPTURE

980

How do y read Sequential file from job control?

14753

What are sequencers?

715

What is ibm datastage flow designer?

787

What are the important features of datastage?

696

What is job control?

714

What are the some differences between 7.x and 8.x version of datastage?

861