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
- 15927 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
explain about citrix scheduling tool in datastage
what is ds administrator used for?
What is the precedence of stage variables,derivations, and constraints?
Differentiate between hash file and sequential file?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
How a routine is called in datastage job?
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
Why we use surrogate key?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
How and where you used hash file?
I have a few records just I want to store data in to targets cycling way how?
Is the value of staging variable stored temporarily or permanently?
Can you highlight the main features of ibm infosphere information server?
How to clean the datastage repository?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
