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?
- 2 Answers
- 6844 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ashutosh g
use rowsplitter stage
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Name the third party tools that can be used in datastage?
What is the use of datastage designer?
Define ds designer?
Difference between server jobs & parallel jobs?
How many types of sorting methods are available in datastage?
What are the various kinds of the hash file?
What are the types of hashed files in data stage
What are the functionalities of link partitioner and link collector?
What all are the different way to run a job?
What are the components of ascential data stage?
How a routine is called in datastage job?
what is use of SDR function?
How one source columns or rows to be loaded in to two different tables?
What is a merge in datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
