Interested to Buy Any Domain ? << Click Here >> for more details...
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????
- 3 Answers
- 9108 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasad
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
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
What is the project in datastage?
Differentiate between hash file and sequential file?
Differentiate between odbc and drs stage?
What is a quality stage in datastage tool?
What is process model?
how to add a new records into source?
What are the different plug-ins stages used in your projects?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Is it possible to query a hash file?
Can you explain engine tier in information server?
What is apt_config in datastage?
How can you write parallel routines in datastage PX?
How a server job can be converted to a parallel job?
How one source columns or rows to be loaded in to two different tables?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
