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?
Submitted by: Administratorseq file ------> Transformer -------> target
1.extract the source data into seq file.
2.In transformer source column to target , and apply the field function
Field(column name, ',' , 1)
next same drag the source column to target , and apply the field function
Field(column name,',',2)
.
.
.
Field(column name,',',5)
Submitted by: Administrator
1.extract the source data into seq file.
2.In transformer source column to target , and apply the field function
Field(column name, ',' , 1)
next same drag the source column to target , and apply the field function
Field(column name,',',2)
.
.
.
Field(column name,',',5)
Submitted by: Administrator
Read Online Data Stage Job Interview Questions And Answers
Top Data Stage Questions
☺ | Is there any possibility to generate alphanumeric surrogate key? |
☺ | How to reduce warnings? |
☺ | How to remove blank spaces from data? |
☺ | How to design file watch jobs? |
☺ | How to enter a log in auditing table whenever a job get finished? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |