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
Answer Posted / 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 |
Post New Answer View All Answers
What are system variables and sequencers in datastage
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How do you remove duplicate values in datastage?
How to find value from a column in a dataset?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Describe the architecture of datastage?
Can you explain repository tables in datastage?
How to reverse the string using unix?
Define ds designer?
Explain entity, attribute and relationship in datastage?
What are the different common services in datastage?
Describe the main features of 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?
How to read multiple files using a single datastage job if files have the same metadata?