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 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
How do you start developing a datastage project?
How to reverse the string using SQL?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What are the repository tables in datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What are datastage sequences?
Describe the architecture of datastage?
Could anyone give brief explanation bout datastage admin
Differentiate between datastage and informatica?
What is a ds designer?
What is the difference between server job and parallel jobs?
If you want to use a same piece of code in different jobs, how will you achieve this?
What is the purpose of pivot stage and types of containers in datastage
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?