DSXchange

Does your source always have 1 row or it can have multiple rows too? In that case how do you want your column names to be populated?

The default block size is 1000 and you can always set it to 1 if you are particular about the sequence and not just the uniqueness of the values.

You can try something like this :- 2) Use a transformer stage and pass on @PARTITIONNUM system variable value to some output column for eg:- Part. Use Round robin partition on the input link. Round Robin may not necessarily used..depends on the data in specific cases and hence aggregation on the @P...

gaurav_shukla wrote:Use NullFieldvalue property of Sequential stage.

Decimal - NullFieldvalue=0

0 (Zero) might actually be a valid value for a number field.There is no "NULL" in a file and it is empty that actually is populated in a file and hence NullFieldValue='' works fine in common.

I assume by default datastage assigns Round Robin to a stage following a stage running sequential mode.

Lookup is rght after the connector(source) .The connector is running in Sequential mode and I made Auto partition in lookup.When I tried parititioning the data on a field Item.I made hash partition on input and entire on the reference.The results were not as expected even in that case.

Hi All, I developed a job with Oracle Connector as source ,then a lookup stage with 4 reference links out of which one link is a dummy lookup to populate a batch id and the other three come from a single oracle connector with a copy stage after that.The three reference links do not have any duplicat...

Null tolerant stage variables were introduced in v8.5

for point 2:
Lookup defaults a string output column to 'Empty',numeric to 0(Zero) and date/timestamp to '*****'(not sure of number of stars) if output is not nullable and there is not match on the keys.

Entry level developers gain enormous knowledge, apt troubleshooting techniques and can guide themselves in the right direction by going through this forum/site.

Convert('.','',DecimalToString(Col))

-Oracle Enterprise stage runs in sequential mode when used as source but connector can be run in parallel using different parallel read options. -Also connector is said to be faster than Enterprise stage. -Connection can be saved and can be reused. -Error/rejects can be captured with an error code a...

can be use Aggregator stage for that or compare the two records using join or merge stage after that use aggregater stage Apparently,there are no common values expected in the two sets so we cannot porceed with the combining stages.However you can try compare stage but even that stage requires same...

Please put the values in tabular format so that it will be easy for you to pose your question..

Where are you writing this derivation? What is the datatype of the field/variable where you are writing this expression?