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
- 8508 Views
- I also Faced
- E-Mail Answers
Answer Posted / blueboys
Dear Srinu,
I am accepting your answer , but I need it by
using data stage functions
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
how to export or import the jobs in .ISX file
Highlight the main features of datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is the importance of the exception activity in datastage?
What are stage variables?
Which algorithm you used for your hashfile?
Where do the datastage jobs get stored?
Does datastage support slowly changing dimensions ?
To see hidden files in LINIX?
Lookup constraints
Demonstrate experience in maintaining quality process standards?
Define data aggregation?
What is a merge?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Differentiate between operational datastage (ods) and data warehouse?
