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
- 16574 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
I have a few records just I want to store data in to targets cycling way how?
describe the Steps to confiure a Qlogic switch
How a source file is populated?
What is the use of datastage director?
What is usage analysis in datastage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Define oconv () and iconv () functions in datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
How to read the length of word in unix?
Is it possible to query a hash file?
Give an idea of system variables.
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What are the types of hashed files in data stage
How do you start developing a datastage project?
What is a quality stage in datastage tool?
