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
- 10964 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 |
What is a quality stage in datastage tool?
What is a ds designer?
how do u capture duplicates through sort & transformer
Terminate Activity
How do you run datastage job from the command line?
Define oconv () and iconv () functions in datastage?
i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?
how do u catch bad rows from OCI stage? And what CLI stands for?
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.
1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?
what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?
what is normalization and denormalization
Teradata 
