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


Please Help Members By Posting Answers For Below Questions

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?

1046


Can we use target hash file as a lookup ?

2815


Define oconv () and iconv () functions in datastage?

878


Explain entity, attribute and relationship in datastage?

635


What are the various kinds of containers available in datastage?

563






what is 'reconsideration error' and how can i respond to this error and how to debug this

2119


what are the errors,warnings in datastage

2149


How do you start developing a datastage project?

660


Why we use surrogate key?

697


How do u convert the columns to rows in datastage?

692


how to delete one row in target dataset

2587


What are transforms and what is the differenece between routines and transforms?

614


If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

1625


What are the different layers in the information server architecture?

641


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

1631