Interested to Buy Any Domain ? << Click Here >> for more details...
i want send my all duplicate record one tar and all uniq
records one target how we will perfome explain
example:
input data
eid
251
251
456
456
951
985
out put/target1
251
251
456
456
out put/target2
951
985
how we will bring
- 13 Answers
- 20164 Views
- Bank Of America, IBM, I also Faced
- E-Mail Answers
Answer Posted / msbharathi
- > Unique
Sq File - > Aggregate - > Transformer |
- > Duplicate
1. Read data in seq file stage.
2. In Aggregate stage group by EID and count the number of rows in Count column
3. In transformer stage create loop condition as @ITERATION<= DSLink6.Count and derivation as EID = EMPNO.
4. In unique output tab use constraint count<=1 and in duplicate output tab use constraint count>1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Differentiate between validated and Compiled in the Datastage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is ibm datastage flow designer?
What are the various kinds of containers available in datastage?
How do y read Sequential file from job control?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
root tree will find which is server job and which is parallel job?
What is a merge?
How many Key we can define in remove duplicate stage?
How and where you used hash file?
What are the different layers in the information server architecture?
how to export or import the jobs in .ISX file
Define repository tables in datastage?
Difference between data warehousing and olap?
