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
- 15926 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / shiva
In the transformer stage we have funcitons like alfa and
numaric so we go for that stage and write one condition if
alfa() then target1 and then go for constraints then put the
otherwise option then automatically numaric values will be
stored in anthor target table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a merge?
Does datastage support slowly changing dimensions ?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are the some differences between 7.x and 8.x version of datastage?
Define Merge?
how do u catch bad rows from OCI stage? And what CLI stands for?
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 usage analysis in datastage?
What is the difference between in process and inter process?
If you want to use a same piece of code in different jobs, how will you achieve this?
What is datastage engine?
How do you import and export data into datastage?
What a datastage macro?
What are the different options associated with dsjob command?
