DSXchange

Hi,

The best way to capture rejected data is LookUp Stage.
U can send matched records to one table and rejected records to one table.

Regards,

Hi,

Use LookUp to catch the rejected rows.U take two Target Tables.So that u
can pass matched values to one table and rejected rows to another table.

Regards,

Hi,

U can do this like the following.

BEG_DATE:DATE=NullToValue(BEG_DATE,'1800-01-01')

i think it works fine.

regards
narayan reddy.g

Hi,

I think u enabled "Allow multiple instance" option in Ds Designer.

and while running in Ds Director it asks name of instance u give .

for example if job name is sort then u can give sort.1,sort.2

it will work fine.

Hi , Change Capture is used to track the old and new values in the slowly changing dimension table.If there is huge amount of data then we use Change Capture Stage. Difference is also used for the same purpose but for small amount of data. it checks Column by Column. Always try to use ChangeCapture ...

Hi All,

Orchestrate itself is an ETL TOOL which supports Parallelism techniques.
it is used to execute the jobs in parallel.
IBM Purchased Orchestrate and integrated in the Datastage in order to support parallelism.
Orchestrate generates OSH Code which is Executable.

Hi All, Incase of loading data into target oracle table its better to use ORABULK Stage as performance increases.Also to reduce space try to use VARCHAR instead of CHAR. Also remove indexes while loading the data into the table.After Loading rebuilt all the necessary indexes. Try to use SQL Statemen...

Hi, first of all use varchar instead of char as it reduces the memory space. while loading bulkdata try to use orabulk stage for oracle table or BCP Loader for SQL Server or Sybase.Try to use indexes while loading the data as performance increases. Try to use SQL Statement while Extracting the data....