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

I have a input as:

Col
1
1
2
2
3

I want 3 output as:

Output1:

1
1

Output2:

2
2

Output3:

3

i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

Question Posted / ankit kansal

Answer Posted / ankit kansal

Hi, if you know the number of duplicates coming your from source then it's easy to move the duplicates to the defined target using router transformation easily,
But if you do not know the number of duplicates then first you must sort the data on the value of duplicate column and then using Transaction Component as available in informatica you can create n no of targets depending upon the values encountered.

http://deepinopensource.blogspot.in/

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe the architecture of datastage?

572

How to manage date conversion in Datastage?

640

What is a datastage job?

622

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

602

Demonstrate experience in maintaining quality process standards?

1939




Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1751

What is meta stage?

580

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

677

Difference between server jobs & parallel jobs?

655

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)

1900

What are stage variables, derivations and constants?

672

Describe link sort?

650

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

3503

Differentiate between operational datastage (ods) and data warehouse?

674

How to implement complex jobs in data stage?

618