DSXchange

What my understanding is :
Scratch is temporary memory and when we say resource disk it means permanent memory or disk .

Please correct me if I am wrong.

Sorry
what I meant was look up keeps reference data into scratch

is it right now?

parallel job dev guide explains types of partitioning. Depending upon your requirement, you might want to go for round robin or hash or modulus or random partitioning to achieve the same.

Hi,

Lookup using scratch memory while join uses disk(physical) memory for the sorting it performs.

is it a right statement to make?

try this:

Trim(DecimalTostring(In.Col),'0','L')

Thanks to all of you!!!!

but I don't have sequential stage. It's just some input I have say dataset where I need to assign sequence number.

Now I can't use sequential stage as I have billions of records so it might be very time consuming if I use so.

Is there any way of keeping track of record counts across nodes?

Create an extra column in your sequential stage and set the option Row Number column in Properties tab to this extra column. This will generate sequential number. But the number starts from zero. You can add one to it in the transformer anbu, But it's running on multiple node so what would happen e...

input is decimal

i ma getting very much confused now

how would it know in the example i gave in my first question in this thread that it has to take these values as dates to compare them to get maximum or minimum value

Hi All,

I need to generate sequence number in my input file. say if i have 10 records they should have sequence number 1, 2, ,3 .... 10. the file is being run on 5 node configuration system. how can I assign it while file is being split between 5 nodes?

no no

it was date which had been read as decimal only. now i asked character because you talked about string comparison. Date came from the example you gave that string can be compared but the example you gave was of a date so it had to be read in as date right?

Although you can test it for yourself in a couple of minutes, the answer is that you can do string comparisons, e.g. "2010-01-23" < "2010-01-26". In your case the format is YYYYMMDD so a greater/less than comparison will work. But for that variable is to be defined as date right...

use wc -l

can we do a string comparison in data stage

as in suppose stagevar1 = "abc" and stagevar2 = "fgh"

so if I do

stagevar1>stagevar2

what would be the answer I would get?

Thanks for the inputs !!!