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 / 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
Define orabulk and bcp stages?
What is use Array size in datastage
What are constraints and derivations?
Explain usage analysis in datastage?
Can you implement SCD2 using join, transformer and funnel stage?
What is merge stage?
Name the third party tools that can be used in datastage?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Why do we use exception activity in Datastage?
project Steps,hits, Project level HArd things,Solved methods?
How to Remove Duplicate using SQL?
Explain the importance of surrogate key in data warehousing?
What are system variables and sequencers in datastage
Differentiate between Join, Merge and Lookup stage?
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.