if a column contains data like
ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to
place names separated by commas in another columns how can
we do?
Answer Posted / abhishek
No Need of fileds and all extraact al the columns in
transfarmerstage create a new column in transe as exprestion
col1,col2,col3 and load it
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Define data aggregation?
How can you write parallel routines in datastage PX?
how to abort the job its matain duplicates?
What are the stages in datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
How to convert RGB Value to Hexadecimal values in datastage?
What is use Array size in datastage
explain about citrix scheduling tool in datastage
What is "fatal error/rdbms code 3996" error?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How to manage date conversion in Datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is the purpose of pivot stage and types of containers in datastage
how to add a new records into source?