source
1123445
I WANT OUTPUT AS
DUPLICATES TO TARGET1 LIKE
TARGET1
1144
NON-DUPLICATES TO TARGET2
TARGET2
235
Answer Posted / siva
seq.file-->copy-->agg
! !secondary link
!.....>join-------->filter-->t1
primarylink !---->t2
agg:countrows
give condition in filter
count=1-->t1
count<>1-->t2
Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
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?
Can we use target hash file as a lookup ?
Define oconv () and iconv () functions in datastage?
Explain entity, attribute and relationship in datastage?
What are the various kinds of containers available in datastage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
what are the errors,warnings in datastage
How do you start developing a datastage project?
Why we use surrogate key?
How do u convert the columns to rows in datastage?
how to delete one row in target dataset
What are transforms and what is the differenece between routines and transforms?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What are the different layers in the information server architecture?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination