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 / 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
What are the components of datastage?
How to manage date conversion in Datastage?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How many types of stage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Explain how a source file is populated?
What is ibm datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is "fatal error/rdbms code 3996" error?
What could be a data source system?
On which Dimension Table you implemented SCD Type in your Project
I have a few records just I want to store data in to targets cycling way how?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are the differences between datastage and informatica?
table actions available in oracle connector?