DSXchange

Prasad,

when you say that it isn't working "from ETL" does that mean from DataStage? Which stage and and how are you calling the SQL? It might be that you are doing a second encryption by misteak <sic>.

Yes, you can move without worries in this part of the transition. The dataset descriptors don't contain a a server name reference, just the schema information and the paths to the actual data files.

Create a stage variable called "DaysDiff" with your date subtraction
In your derivation for column C use . Note that the answer for a difference of 1096 is the same formula as for => 365.

I think I need to digest this a bit, but it doesn't seem (at first reading) that you need anything recursive or even multiple pass - since the 2nd file is of no consequence to you. Can you look at the problem as if it were a machine with two "states" - one before the mode switch, and one after. From...

There is no single builtin function in PX to let you do this. You will need to convert your Month number (based on what first month?) into an actual date and then use the [bold]DateFromDaysSince[/bold] to get a number of date using a average of 30 days/month, or use 29 and accept a possible error on...

If you are getting your restart message after the reinstall is complete, you might be able to get away with restarting the services from the control panel.

I agree with Ray and Kim. Look at it this way - a program will always try to run as quickly as possible. If it is CPU bound it will grab 99.9x% of the CPU if it can (leaving just enough for the OS) or if it is I/O bound it will grab 100% of the I/O. Since there are always other things goings on with...

In order to get back into sync, check the create and check the delete-before-create options.

You asked for a running total in your other threads, that (to me) means a the current total-to-this-record for each row. If you want one row output with only the sum of a particular column's values then the aggregator stage is what you want. The transform stage never "knows" that it has the last row...

parag.s.27, this is a premium post; it gives information that is more detailed than normal and is meant for those who are serious enough about their work and use of the DSXchange forum to join and pay the annual membership. I have unmarked the post as "premium" to let you see what you did miss the f...

Unfortunately if you wish to use INDEX() you will need to do some sort of a loop, checking the string for each substring in your list sequentially. The DataStage pattern matching mechanism will work for you here, though. You can use an expression such as In.Column MATCHES "0x'ELEC'0x":@VM:...

You only need to ask 1 time (you've now posted the same question in 3 places within a couple of minutes - including a thread from last year!) Running total is easy. If you have a column In.Col1 that you want a running total on, create a stage variable "RunningTotal" and just assign "RunningTotal + I...

Running total is easy. If you have a column In.Col1 that you want a running total on, create a stage variable "RunningTotal" and just assign "RunningTotal + In.Col1" to it and output that to a column.

Running total is easy. If you have a column In.Col1 that you want a running total on, create a stage variable "RunningTotal" and just assign "RunningTotal + In.Col1" to it and output that to a column.

Magesh - note that you are now showing a different error than originally, which is why Ray asked the question. You have a pointer in your VOC file that points to a non-existant file on the system. I think if you were to modify your hashed file settings to also "DELETE file before create" it will rem...