Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
I am getting data from sequential file like below
column1
A&B
C&D
A&E
X&Y&Z
v&x
But I need the target column as like below
column1
A and B
C and D
A and E
X and Y and Z
v and x
- 7 Answers
- 11456 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / lakshmi srinivas
By using convert function in transformer,we can implement
that....
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / manish
Using Convert function we can achieve this:
Convert('&',' and ',column string)
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / srinu
using sequential file using unix command sed s/&/and/g we
will get answer
| Is This Answer Correct ? | 2 Yes | 1 No |
hi,
please take a look on below,
seq_src------->ext_flter----->seq_tgt
in external filter give the
filter command = sed s/"&"/" And "/g command.
**Note: on ampersand (&) symbol you must give the double
quotes (""). With out this it doesn't populate.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sree
using expersion
u can create o/p in that write
replacestr(1,columnname,'&','and')
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / srinu
hi blueboys
only that answer is proper answer.....interview expected
that answer only.........datastage it is not possible........
| Is This Answer Correct ? | 1 Yes | 1 No |
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How do you start developing a datastage project?
Difference between the Sequence and Sequencer in DS?
Explain usage analysis in datastage?
Is the value of staging variable stored temporarily or permanently?
what is the difference between the active datawarehouse and datawarehouse
what is diff b/w datastage 8.1,8.5,8.7?
file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks
client know skid info?
How do you import and export data into datastage?
What are the stages in datastage?
What steps should be taken to improve Datastage jobs?
Teradata 
