Interested to Buy Any Domain ? << Click Here >> for more details...
I have source file which contains duplicate data,my
requirement is unique data should pass to one file and
duplicate data should pass another file how?
- 7 Answers
- 24856 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / farzana kalluri
input output
1 T1 T2
2 4 1
2 6 2
1 7 3
3 4
4 5
3
5
5
6
7
for this
seq file---->Aggregate(key=id)---->filter---->2 targets
In aggregate use count rows...
in filter count=1 it goes to target1
if count=2 it goes to target2..
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
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
How do you register plug-ins?
Name the third party tools that can be used in datastage?
What is process model?
What is the purpose of pivot stage?
Can you define merge?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What is active and passive stage?
What are the benefits of datastage?
Name the command line functions to import and export the DS jobs?
Have you have ever worked in unix environment and why it is useful in datastage?
State the difference between an operational datastage and a data warehouse?
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
What is difference between symmetric multiprocessing and massive parallel processing?
What is a folder? Difference types of stages?
