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
- 16579 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 the use of skid in reporting?
On which Dimension Table you implemented SCD Type in your Project
What is the command line function to import and export the ds jobs?
How to manage date conversion in Datastage?
How many types of stage?
What is process model?
Define data aggregation?
Can you implement SCD2 using join, transformer and funnel stage?
how to sort two columns in single job in datastage.
Is the value of staging variable stored temporarily or permanently?
What are the different kinds of views available in a datastage director?
Explain how a source file is populated?
What are the components of ascential data stage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is the purpose of pivot stage?
