DSXchange

Hi, Need some information about at situation where wirting a same dataset files in differnt output/target folder for example I am writing a SampleDataSet.ds in /path/firstenv/SampleDataSet.ds and the second one with the same name as SampleDataSet.ds in /path/secondenv/SampleDataSet.ds and i am using...

Hello Guys thanks for the different kind of inputs and solutions. Kim, We need this to be done with out high priority but we need to have this cross referrence some time next month. I will try doing some solutions provided. Keep you posted, but if any one has come up with good solutions please share...

HI,

Is there a way to find out in PX, what all ETL jobs been used a particular Table or File?

As we are using ODBC section and used User Defined SQL's.

Any Help is appreciated.

thanks

narasimha wrote:Check this post
Do a reindex, but this time with exclusive access to DataStage.

Thank you guys!
i followed the process and it solved the issue

narasimha wrote:I am sure you would have done this.
But while re-building the index did you make sure nobody was logged on?

I think there was some one logged in.
So what would be the option to bring back the Categories and Jobs?

thank

we tried to run the re-build index using DS.TOOLS option and looks like to aborted in between. When we log og back to DS designer we are not able to see any categories under JOBS folder? Any reason why are not able to see them? But we can open the recently opened ETL jobs from DS Directory - so look...

Welcome aboard :D You can get that value directly in the stage var. Write a before job routine or script to extract max SL_NO and assign it one job parameter. Then use this parameter while generating the SL_NOs. But as the job will be parallel, you will have to take care of parallelism while genera...

chulett wrote: First select and land the records from the table. Then a separate job to truncate and reload. Two steps.

I did split the job into 2 jobs - one create a load file and the next job to truncate and insert the new load file.

Thanks for the Information.

~Titto

Hi, I am trying to select from a Table-A using ODBC section in the process and funnel the records with new records and Truncate and Write the new records to the Table-A. But when i am tying to select from Table-A, it is not fetching any records as the Table-A has no records - but there are records i...

Hi,
can we use CheckSum in PX environment ?
may be a dumb question - when i tried in PX job it says function not there, but tried search in PX message board i found 3 hits.

thanks

When using NEXTVAL in the INSERT statement you don't get the value back. That's the whole point. It's faster. Hi Ray, but i need the latest Sequence number to write out to a file, can i use CURRVAL after the NEXTVAL (Insert statement) - in next stage, can it give the recently inserted value? please...

I don't like this design as the sparse lookup is a very expensive overhead on your job. You've got to ask what advantage you are getting from using a DB2 sequence when you have to retrieve it for every row. I think you would be better off generating keys within your job using a parallel counter, re...

There could be other jobs creating new surrogate keys on the same table at the same time. I presume the solution you suggest relies on this being the only job creating the key. Hi HSBCDev, I have same kind of requirement and i need the sequence number to write to a file so that there are other proc...

Hi Ray, For small volume of data, a BASIC Transformer stage could serve here. Use Oconv(Iconv(TheDate, "D"), "DQ") to generate the quarter number (1, 2, 3 or 4). Then take the remainder after dividing the quarter number into the month number, added to the month number. Use the Mo...

I got it correct, and working fine

I used following SQL If are they any other way please let me know!

Thanks,