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
- 16037 Views
- Patni, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mike
in transformer stage, used Alpha function which
Checks if a string is alphabetic or not. if its return
value is 1 then alphabetic.
| Is This Answer Correct ? | 8 Yes | 0 No |
source->transormer->fileter1->transformer1
->filter2 ->tranformer2 joinstage ->target
in source:-
take i/p
transformer :
append new collumn and apply char function is alpha
filter1:
separate 0
filter2:
separate 1
transformer1
add another column @outrownum
transformer 2
add another column @outrownum
we join on @rownum column we will get
do perfect we get answer
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vaka
In Transformer stage, used Num function which
Checks if a string is alphabetic or not. if its return
value is 1 then alphabetic,0 then Numeric after using
filter give the where clause=0 output link 0(trg1) and
where clause=1 output link 1(trg2)
trg1
123
234
768
567
789
trg2
abc
def
jkl
opq
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
Answer / 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 |
Answer / srinu
at first generate row number column column 'number' then in transformer stage
create one column in constrains [ mod(number,2)=0] for this logic we get all even records mean all strings to one target
and for the second target kept a reject link all the numeric get a side
| Is This Answer Correct ? | 0 Yes | 0 No |
how does work server jobs?
i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?
What is the difference between validated and compiled in the datastage?
i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is the command line function to import and export the ds jobs?
source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.
Why we use parameters instead of hard code in datastage.
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?
What is ds designer?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
Teradata 
