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
- 16257 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
I have a few records just I want to store data in to targets cycling way how?
How many areas for files does datastage have?
How to reverse the string using unix?
What is ibm datastage flow designer?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Define repository tables in datastage?
What are the functionalities of link partitioner and link collector?
what is repositery?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
what is the use of skid in reporting?
What is size of a transaction and an array means in a datastage?
Can you explain kafka connector?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Differentiate between operational datastage (ods) and data warehouse?
