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
- 24322 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.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
how to export or import the jobs in .ISX file
What are some prerequisites for datastage?
What is the difference between informatica and datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Name the different types of Lookups in Datastage?
What are the types of containers in datastage?
What is quality stage?
How do you schedule or monitoring the job?
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 usage analysis in datastage?
On which interface you will be working as a developer?
What is the flow of loading data into fact & dimensional tables?
Define project in datastage?
What are constraints and derivations?
