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 / ashutosh g
use rowsplitter stage
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you generate sequence number in datastage?
What is the flow of loading data into fact & dimensional tables?
What are the types of containers in datastage?
How do you reject records in a transformer?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Explain entity, attribute and relationship in datastage?
What is difference between join, merge and lookup stage?
What are datastage sequences?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
How do y read Sequential file from job control?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
how to write server Routine coding?
Which commands are used to import and export the datastage jobs?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
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?