vertical pivot
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 37
- Joined: Fri Sep 30, 2005 10:05 am
- Location: va
vertical pivot
Hi all
I have been looking at this particular post in the server
viewtopic.php?t=97681&highlight=vertical+pivot
I have seen Rays and jims replies but can u guys throw some light when we are working with parallel(As we don't have hash file here) how to implement this.
Thanks
smita
I have been looking at this particular post in the server
viewtopic.php?t=97681&highlight=vertical+pivot
I have seen Rays and jims replies but can u guys throw some light when we are working with parallel(As we don't have hash file here) how to implement this.
Thanks
smita
PX has no update-able reference data set capability. For PX, you're going to have to either write a custom buildop or use the obscure Make Vector stage to do what you need.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 37
- Joined: Fri Sep 30, 2005 10:05 am
- Location: va
Not right now. I'm still working on developing a Bag of Tricks for PX, which could include such functionality. But it's not ready to share.
Unless you have obscene volumes, you could still use a Server job prep the data using a hash file, and then dump it out to a sequential file. Then, use a PX job to feed that file into a dataset.
A mixed bad approach is my recommendation for PX sites. Use the tools appropriate, if it's a shell script, SQL script, Server job, PX job, or blend of those.
Unless you have obscene volumes, you could still use a Server job prep the data using a hash file, and then dump it out to a sequential file. Then, use a PX job to feed that file into a dataset.
A mixed bad approach is my recommendation for PX sites. Use the tools appropriate, if it's a shell script, SQL script, Server job, PX job, or blend of those.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
For anyone comfortable with multi-valued fields (for example in UniVerse or UniData), the Make Vector stage should not be daunting. A vector is simply a list of values in the one field.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 37
- Joined: Fri Sep 30, 2005 10:05 am
- Location: va
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Challenge that decision. It is based on a false premise, which you can find by reading recent posts here about server jobs (not) going away.smitageorge wrote:I understand that but i am not allowed to use server at the site.kcbland wrote: A mixed bad approach is my recommendation for PX sites. Use the tools appropriate, if it's a shell script, SQL script, Server job, PX job, or blend of those.
Thanks
smita
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 37
- Joined: Fri Sep 30, 2005 10:05 am
- Location: va
To my understanding:
Your Src:
NO ........... TYPE
1 ....................A
1.................... B
1.................... C
1.................... D
Create Temp with metadata like this
NO ... Type1...Type2...Type3...Type4
1 ..... A......... B .........C ......... D
Map the each of them to the temp file.
Then if you want them together depending on your requirement, concatenate type1:type2:type3:type4 and map them again to the target.
For this design you need to know the Max number of types you are going to have as this design would static metadata handled.
If you dont know the max types then you will have to write a routine to handle them. Or someone might come up with another option.
Good Luck
Your Src:
NO ........... TYPE
1 ....................A
1.................... B
1.................... C
1.................... D
Create Temp with metadata like this
NO ... Type1...Type2...Type3...Type4
1 ..... A......... B .........C ......... D
Map the each of them to the temp file.
Then if you want them together depending on your requirement, concatenate type1:type2:type3:type4 and map them again to the target.
For this design you need to know the Max number of types you are going to have as this design would static metadata handled.
If you dont know the max types then you will have to write a routine to handle them. Or someone might come up with another option.
Good Luck
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Charter Member
- Posts: 130
- Joined: Mon Sep 06, 2004 3:05 am
- Location: Dubai,UAE
Hi Smita,
Can be easily be done using stage variables.
You can search the forum and find how to implement this using stage variables.
In case you do not find it I will post it by tomorrow morning.
Can be easily be done using stage variables.
You can search the forum and find how to implement this using stage variables.
In case you do not find it I will post it by tomorrow morning.
Warm Regards,
Amruta Bandekar
<b>If A equals success, then the formula is: A = X + Y + Z, X is work. Y is play. Z is keep your mouth shut. </b>
--Albert Einstein
Amruta Bandekar
<b>If A equals success, then the formula is: A = X + Y + Z, X is work. Y is play. Z is keep your mouth shut. </b>
--Albert Einstein
-
- Participant
- Posts: 37
- Joined: Fri Sep 30, 2005 10:05 am
- Location: va
-
- Participant
- Posts: 37
- Joined: Fri Sep 30, 2005 10:05 am
- Location: va
Sunshine2323 wrote:Hi Smita,
Can be easily be done using stage variables.
You can search the forum and find how to implement this using stage variables.
In case you do not find it I will post it by tomorrow morning.
Hi amruta,
I tried the stage variable but might be you are having some good understanding of this .Please post it .
Thanks
smita