DSXchange

kcbland wrote: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. ...

Can you help me with that ken.

Thanks
smita

Hi all I have been looking at this particular post in the server http://www.dsxchange.com/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. Tha...

Thanks Arnd and Ray for your help.

smita

ArndW wrote:The lookup generated more than one return row.

Hi Arnd,

I need to get all the rows.

Thanks
smita

Hi all,

While doing a lookup i am getting following warning in the job log.Can anyone tell me why is it so?

LKP_ITS_BCBS,0: Ignoring duplicate entry at table record 2; no further warnings will be issued for this table

Thanks
smita

rasi wrote:Nagesh

Simtha is using /dev/null as Sequential file path

Also Siva,I am using /dev/null as the seq file path for the testing purpose

Regards

It wis working file after giving the proper path.But y it is like that?

thanks all
smita

Hi all,

Can anybody help me in understanding the development to prod cycle.This is the first time i am going beyond the development.

I would like to know for testing what do i need to send like the .dsx file for the jobsequence and the individual jobs, parmscript and whatelse?

Thanks gurus
smita

kkreddy wrote:Dear Guru's
i am unable to export jobs as xml from dsmanager, it is showing

noobjects were found to export

.
what could be the reason .

thanks in advance for ur reply

Regds
Kiran

Hi Kiran

Have you made a proper selection on the XML tab?

smita

Hi Rob, I am able to view the data in the source Dataset and also on the canvas it is showing that 9 rows are processed and passed to seq file. But the thing is that when i am using dataset instead of seq file i am able to view the data there. Also Siva,I am using /dev/null as the seq file path for ...

Hi all, I am trying to do a simple move from dataset to sequential file and in between using the remove duplicates stage .The job is getting compiled and is running good but when i am trying to view data it is giving following error: No row are returned from the view data server command would you li...

It can be simple. But you should put a lot of thought into it. You are going to want to use this for all of your incremental job builds, you should not implement a control table process like this without considering your overall plan. Not just the plan for this one particular job. Hi william, Any a...

Hey I am trying to do the initial load. I had to create a seq file with only one field (i,e; Timestamp) and i am using this file as a lookup in my main job and checking the create date in the source table with this. If create date is greater than timestamp from file i need to extract the dataand i n...

Hey I am trying to do the initial load. I had to create a seq file with only one field (i,e; Timestamp) and i am using this file as a lookup in my main job and checking the create date in the source table with this. If create date is greater than timestamp from file i need to extract the dataand i n...

Hi KC, I think i haven't given the correct information. I am having 2 colums in input ID,DEL 5,7 5,2 7,3 7,4 7,5 8,2........ In the Output I need something like this New,ID,DEL 1,5,7 1,5,2 2,7,3 2,7,4 2,7,5 3,8,2 ......... whenever the ID value is changing I should have an increment of 1 in New colu...

Hi all,

How about if we need to compare the previous value with the present value.And have the result as:
If equal it should be same or else increment by 1.

Thanks
Smita