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
- 24229 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
Difference between in process and inter process?
What are the job parameters?
Notification Activity
What is the differentiate between data file and descriptor file?
Differentiate between validated and Compiled in the Datastage?
how to delete one row in target dataset
Is it possible to query a hash file?
What are the types of jobs we have in datastage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
If you want to use a same piece of code in different jobs, how will you achieve this?
What are the differences between datastage and informatica?
What are the different layers in the information server architecture?
What is active and passive stage?
What are the steps needed to create a simple basic datastage job?
