DSXchange

Hi All, We have a requirement to create a generic job for processing multiple extract files. As part of this requirement we have to make certain validations. Since the datastage job would be RCP enabled. We want to implement a C++ code (with required fields as arguments) and call it through generic ...

Yes. The size of each data type is documented (from memory in Chapter 2 of the Parallel Job Developer's Guide ). Add these together for all the columns in the row that you're processing, then ... Hi Ray, Sorry I didn't post my question properly. After calculating the size, how can we determine whet...

Hi,

Is there any way to estimate the max possible size of data that can be used as secondary link for Lookup Stage.

Thanks

Are you renaming from "input0Int8nLDD_X1" to "X1"? Is the source field Not Null? ... Hi Kumar, I am not renaming the field input0Int8n_X1 (it was generated internally within datastage) Is X1 nullable in your source link? Hi, X1 is nullable in source (secondary link) Probably you...

I am doing left outer join using Join Stage. X1 is non-key field from secondary link.

Hi All, I am getting the following error from the transformer When binding input interface field "input0Int8nLDD_X1" to field "X1": Using "notnull" conversion with non-nullable input. I am using a left outer join and checking the value of a hardcoded field X1 of seconda...

Thanks for the example of sort.

could you let me know scenario when detrimental added partitioning is introduced by datastage and how to overcome it.

(verbal example as earlier would be sufficient)

Since dataset doesn't get created when no records are written to it due to constraints in transformer (or any other stage).

What would be the best approach to create an empty dataset? As this should be called in multiple jobs with dataset name as an argument.

Thanks for the responses. Can you please provide with an example (score dump) before and after (performance tuning) scoredump .... I found the below in Advanced Developer's Guide The score dump is particularly useful in showing you where DataStage is inserting additional components in the job flow. ...

A1) Look more carefully at the output structure of each. A2) Please advise in which manual you found the scenarios. A3) No. ... A1) I see the difference in DiffCode() and ChangeCode(). But couldn't find the difference in functionality A2) I found the below in Advanced Developer's Guide The score du...

Hi, I am trying to learn parallel extender from documents (no software installed). Q1) I didnt find any difference between DIFF stage and CDC Stage. Functionally both are 100% same. Did I miss anything from documentation? Q2) I tried to read about scores and situations that could help in identifying...

mandyli wrote:Yes. You are right..

All the plug-in stage needs to use depend upon your requirements.

Better to use all native Enterprise stage is always good.

what are the others used for i.e. the oci, cli stages and again when to use load vs load express stage

Hi,

For almost every database plugin we have OCI, Enterprise, CLI, Load, Load Express.

What are the differences between these stages. i.e. when to use them?

Load Express - This appears as a direct load in SQL loader. Am I right?

Thanks

Hi all, I have few newbie questions. PS: I don't have PX installed to verify (I am just going through documents) a) external filter - can we write any unix command (rm/find/grep/awk/sed/cut...) etc? b) Can I write unix scripts to process .ds files (just as txt files) and use external filter c) Does ...

But why is it important to sort before these stages?