LinkCollector Issue
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
LinkCollector Issue
hi,
I am using a LinkCollector to read from 2 sources with identical structure and write it to a flat file which has output to a transformer. If it extracts 20 records from each link, the total of 40 records are loaded into the flat file but only 20 are returned to the end transformer!
Link1 (20 records)
} LinkCollector(40)--->FlatFile (40)-->Transformer(20)
Link2 (20 records)
Any way to work around this issue.
Thanks,
I am using a LinkCollector to read from 2 sources with identical structure and write it to a flat file which has output to a transformer. If it extracts 20 records from each link, the total of 40 records are loaded into the flat file but only 20 are returned to the end transformer!
Link1 (20 records)
} LinkCollector(40)--->FlatFile (40)-->Transformer(20)
Link2 (20 records)
Any way to work around this issue.
Thanks,
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Participant
- Posts: 232
- Joined: Sat May 07, 2005 2:49 pm
- Location: USA
Hi Vinay,
1) Try to do view data for the link between the flat file and the transformer. It is a possibility that you are not able to read all the records from the flat file, for some reason. If you dont have any constraints in the transformer, then you should see all the 40 records in its output.
2) Alternatively, you can put the following system variables (@INROWNUM and @OUTROWNUM) in the tranformer and observe what those values are. This might give you a clue about what's happening.
3) Try to put break points before and after the transformer and run the job in the debug mode and observe how many rows are being processed.
I hope this helps.
1) Try to do view data for the link between the flat file and the transformer. It is a possibility that you are not able to read all the records from the flat file, for some reason. If you dont have any constraints in the transformer, then you should see all the 40 records in its output.
2) Alternatively, you can put the following system variables (@INROWNUM and @OUTROWNUM) in the tranformer and observe what those values are. This might give you a clue about what's happening.
3) Try to put break points before and after the transformer and run the job in the debug mode and observe how many rows are being processed.
I hope this helps.
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Charter Member
- Posts: 199
- Joined: Tue Jan 18, 2005 2:50 am
- Location: India
can i know whatz on the other side of the transformer ? I mean which passive stage you are using after the transformer.
If its any of the databases you have in datastage, then check the director if your 20 "missing" rows are not rejected.
Second thing, I would like to know(jus for my understanding); why do you need a sequential file in b/w link collector and transformer.
You can have ;
If its any of the databases you have in datastage, then check the director if your 20 "missing" rows are not rejected.
Second thing, I would like to know(jus for my understanding); why do you need a sequential file in b/w link collector and transformer.
You can have ;
Code: Select all
link collector1
|---------------transformer-----------next stage
link collector2
Shantanu Choudhary
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Charter Member
- Posts: 199
- Joined: Tue Jan 18, 2005 2:50 am
- Location: India
Still you dont need an intermediate flat file.vinaymanchinila wrote:I am using a flat file the other side.
I need a flat file because the Link Collector does not support active stages.
Just go to Job Properties --->Performance --->click on "Enable Row Buffer" ---> "Inter Process"
or you can also use Inter-process stage, in place of sequential file.
Shantanu Choudhary
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am