Switch case

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

Post Reply
dashpriya
Participant
Posts: 28
Joined: Thu Mar 09, 2006 12:57 am
Location: mumbai
Contact:

Switch case

Post by dashpriya »

Hi ,
How the switch case exactly work?I know that its going to divide the input to number of outouts according to the defined case.If i am having 2 case then how the case is going to work?How is it going to distingusih which case will go to which output link?

Any sujjestion is welcome...

thanks
Dash
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

Output lstreams are identified using link numbers starting from 0. If it is just 2 links, you can use filter stage also.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
dashpriya
Participant
Posts: 28
Joined: Thu Mar 09, 2006 12:57 am
Location: mumbai
Contact:

Switch case

Post by dashpriya »

is it necesssry that the number of columns in input should be equal to the number of columns in output?
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

s it necesssry that the number of columns in input should be equal to the number of columns in output?
can't you find it from job property or from help or from online manual
dashpriya
Participant
Posts: 28
Joined: Thu Mar 09, 2006 12:57 am
Location: mumbai
Contact:

Switch Case

Post by dashpriya »

I am new to PX
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

No problem, you need to read the documents/guide provided.
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Re: Switch case

Post by JoshGeorge »

No it is not necessary ! You can drop columns, but this is completely dependent on the stages you use. You have code to drop columns in modify stage. In copy stage you can drop while you map in the output mapping tab. Check in the stage if it is having a mapping tab, in that case you can try not mapping the columns you don't want to the output link.
dashpriya wrote:is it necesssry that the number of columns in input should be equal to the number of columns in output?
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
dashpriya
Participant
Posts: 28
Joined: Thu Mar 09, 2006 12:57 am
Location: mumbai
Contact:

Re: Switch case

Post by dashpriya »

Thanks a lot for guiding me..
Post Reply