1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / vinod upputuri

Answer Posted / vinod upputuri

First use the seq filestage then use the copy stage after
the copy stage one link is going to agregator stage there we
will calculate the count of records after the agregator
stage use filter stage for finding uniq records then those
records are connected to the lookup as a reference link. the
main link for lookup is comming from copy stage. Then
matching records are uniq else duplicate.

Agre--->filter
| |
Seq--->copy---->Lookup---->uniq
|
|
duplicate.

In agregator use count rows.

Is This Answer Correct ?    14 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have a few records just I want to store data in to targets cycling way how?

1893

Difference between ‘validated ok’ and ‘compiled’ in data stage?

663

How to reverse the string using unix?

2793

How to RD using transformer?

852

How one source columns or rows to be loaded in to two different tables?

654




Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

341

how to implement scd2 in datastage 7.5 with lookup stage

5121

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2424

Have you have ever worked in unix environment and why it is useful in datastage?

641

Differentiate between data file and descriptor file?

612

What is the difference between datastage and datastage tx?

588

Define orabulk and bcp stages?

669

What are the components of datastage?

643

On which Dimension Table you implemented SCD Type in your Project

1571

Describe routines in datastage? Enlist various types of routines.

573