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
- 11165 Views
- I also Faced
- E-Mail Answers
Answer Posted / srinu
using sequential file using unix command sed s/&/and/g we
will get answer
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the stages in datastage?
Difference between in process and inter process?
Can you highlight the main features of ibm infosphere information server?
root tree will find which is server job and which is parallel job?
How you Implemented SCD Type 1 & Type 2 in your project?
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?
What are routines in datastage?
What are the main features of datastage?
What are the repository tables in datastage?
How will you move hashed file from one location to another location?
Can you explain how could anyone drop the index before loading the data in target in datastage?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
I have a few records just I want to store data in to targets cycling way how?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is the process of killing a job in datastage?
