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
How can one find bugs in job sequence?
what are the errors,warnings in datastage
What is data partitioning?
How and where you used hash file?
What is the importance of the exception activity in datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What is the differentiate between data file and descriptor file?
If you want to use the same piece of code in different jobs, how will you achieve it?
What are the partitioning techniques available in link partitioner?
Explain usage analysis in datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is active and passive stage?
What are datastage sequences?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys