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
- 13791 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 difference between join, merge and lookup stage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What are the various kinds of containers available in datastage?
what are the devoleper roles in real time? plz tell i am new to datastage....
How to convert RGB Value to Hexadecimal values in datastage?
how to add a new records into source?
Difference between data warehousing and olap?
What is merge stage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
what is the use of materialized view?
Define repository tables in datastage?
What is the difference between the local container and shared container?
EXPLAIN SCD
What is use Array size in datastage
