Replicating Input Records based on a column value
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 20
- Joined: Sat Aug 09, 2008 1:53 pm
Replicating Input Records based on a column value
Hi,
I have an input source that has a field A. My requirement is that if the length of If the field A is longer than 132 then split the line in as many records to ensure that tha length is not longer than 132 .
Can you tell me the way in which this can be implemented in Datastage. I am not using Datastage in Unix environment, so a unix shell script can not be used.
One other way I guess would be to use a Build - Op stage but I am not sure how that stage is used.
I am working on Datastage 8.0
I have an input source that has a field A. My requirement is that if the length of If the field A is longer than 132 then split the line in as many records to ensure that tha length is not longer than 132 .
Can you tell me the way in which this can be implemented in Datastage. I am not using Datastage in Unix environment, so a unix shell script can not be used.
One other way I guess would be to use a Build - Op stage but I am not sure how that stage is used.
I am working on Datastage 8.0
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 20
- Joined: Sat Aug 09, 2008 1:53 pm
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 20
- Joined: Sat Aug 09, 2008 1:53 pm
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 20
- Joined: Sat Aug 09, 2008 1:53 pm
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom