DSXchange

With any partitioning scheme running on two or more nodes you are not guaranteed that there will be no holes...it's just the nature of assigning a partition-based calculated value in a multi-process environment. Round-robin will evenly distribute so long as the number of rows is a multiple of the nu...

A job sequence can control this. Use the orchadmin command line utility to examine the dataset. Hint: "orchadmin dump n -1 dataset_name" will dump one row from each partition of the dataset to standard output. You could redirect that to a file, then use the unix/linux command wc to count t...

Possible options: 1) Don't run the job if the dataset is empty (a job sequence can control this) 2) Retrieve the timestamp from the sequential file and pass it into the job (job parm, copy of the sequential file, etc.), creating a dummy record with that value and combining it with the records from t...

What do you mean by "not working"? Failing? Not providing the expected result? Have you placed a Peek stage after the lookup to see what values you are receiving?

The output of the Trim() function is a string, not a boolean value.

Regards,

Because you looked for

/opt/IBM/InformationServer/DSComponents/bin/libccora10g.so

instead of

/opt/IBM/InformationServer/Server/DSComponents/bin/libccora10g.so

Regards,

This looks to me to be an issue with unicode vs non-unicode string data. The example from IS 8.5 appears to be a unicode string (2+ bytes-per-character), while the DS 7.5 example appears to be a non-unicode string (1-byte-per-character). As you're moving from Windows to Linux: how was the source fil...

Congrats!

You selected Windows as the operating system when you originally started the thread, thus people's answers will generally be with regards to that choice. Just be as clear as possible with accurate information when you start a new thread in the future :) Why not simply use SFTP directly from one serv...

In v8.5 or above of DataStage, you can accomplish this with a sort and a 2-pass loop in a parallel transformer. In any version, you can accomplish this with a transformer-sort-transformer combination. v8.5+: Partition/Sort on id In the Transformer: Loop Iteration 1: Determine if India is present in ...

If the reference data is NOT Entire partitioned, then only certain reference records will be in certain partitions--this is the essence of partitioning--and the input dataset will need to be identically partitioned in order to match data together. The same is true of the Join and Merge stages. By us...

Check the validity of your format string against the specifications in the product documentation. Pay close attention to the valid formats for month.

Date Formats

Regards,

Most often, the auto partitioning on the reference data will resolve to Entire partitioning. I don't believe I've seen a situation where it hasn't yet, but maybe someone else has.

Regards,

No, it means just as Ray indicated: It does a count on each node that Agreggator is executing on. If you need a single count across all nodes, you must run an Aggregator (or other stage) in a single node (i.e. sequential) in order to combine the counts. Aggregator is no different from other parallel...

You can contact your official support provider for confirmation and assistance, but I don't believe that Windows 8 is a supported platform at this time.

Have you tried the -force option?

Regards,

ps u g eww
or
ps u x eww

would provide an AIX equivalent to ps -efww

Regards,