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
- 9 Answers
- 15928 Views
- Patni, I also Faced
- E-Mail Answers
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
Where the datastage stored his repository?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Differentiate between datastage and datastage tx?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Difference between in process and inter process?
what is ds administrator used for?
State the difference between an operational datastage and a data warehouse?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What is difference between server jobs & parallel jobs?
How to implement complex jobs in data stage?
What is the use of datastage director?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What is ibm datastage flow designer?
