Data Stage Question:

If a column contains data like
abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc,roy,pwe,aaa,xxx,xyz,roy,xok....
how to send the unique data to one source and remaining data to another source?

Answer:

by using create key change column is true is disp;ays
duplicates records
if it is false it displays non duplicate records
first keep all the records in sort order

Read All 11 Data Stage Questions

Previous Question	Next Question
How to get the unique records on multiple columns by using sequential file stage only?	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?

Data Stage Question:

If a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc,roy,pwe,aaa,xxx,xyz,roy,xok....how to send the unique data to one source and remaining data to another source?

Answer:

If a column contains data like
abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc,roy,pwe,aaa,xxx,xyz,roy,xok....
how to send the unique data to one source and remaining data to another source?