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
- 8946 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
Difference between in process and inter process?
What are the different types of lookups in datastage?
Can you highlight the main features of ibm infosphere information server?
Explain the importance of surrogate key in data warehousing?
Define meta stage?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
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
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What steps should be taken to improve Datastage jobs?
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 could be a data source system?
Whats difference betweeen operational data stage (ods) and data warehouse?
Explain usage analysis in datastage?
What is "fatal error/rdbms code 3996" error?
Difference between data warehousing and olap?
