Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
Shruthi
Participant
Posts: 74 Joined: Sun Oct 05, 2008 10:59 pm
Location: Bangalore
Post
by Shruthi » Thu Dec 23, 2010 11:07 pm
Hi,
I have only two stages in a job, source as sequential file and target as SQL Server. I need to know if we have to use copy stage in between. I remember that we were using copy stages in between any two sources (even for seq file to dataset or seq file to seq file) where there was direct mapping.
Is it required to use Copy stage or not?
Harini
Premium Member
Posts: 80 Joined: Tue Mar 16, 2010 1:32 am
Post
by Harini » Fri Dec 24, 2010 12:07 am
We can use copy stage when we want to load our source data into multiple targets, and when store stage does not support multipe links.
Sreedhar
Participant
Posts: 187 Joined: Mon Oct 30, 2006 12:16 am
Post
by Sreedhar » Fri Dec 24, 2010 12:32 am
Hi,
Between any two passive stages we can add copy stage, to avoid segment failures.
Regards,
Shree
785-816-0728
Ravi.K
Participant
Posts: 209 Joined: Sat Nov 20, 2010 11:33 pm
Location: Bangalore
Post
by Ravi.K » Fri Dec 24, 2010 12:33 am
In your scenario, if it is direct mapping then it is not required to use Copy stage. If you want to drop attributes then it is required.
Cheers
Ravi K
Shruthi
Participant
Posts: 74 Joined: Sun Oct 05, 2008 10:59 pm
Location: Bangalore
Post
by Shruthi » Fri Dec 24, 2010 1:40 am
Thanks. We will go ahead and use copy stage as the source and target are passive stages.