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
- 11462 Views
- I also Faced
- E-Mail Answers
Answer Posted / bharath
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 |
Post New Answer View All Answers
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Triggers,VIEW,Procedures
What is the precedence of stage variables,derivations, and constraints?
What are iconv and oconv?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
How can you write parallel routines in datastage PX?
What is the difference between odbc and drs stage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Explain entity, attribute and relationship in datastage?
Is possible to create skid in dim,fact tables?
What is apt_config in datastage?
What is a ds designer?
What are constraints and derivations?
What can we do with datastage director?
