DSXchange

Create a separate configuration file under /opt/Ascential/DataStage/Configurations directory and at job level insert the environment variable APT_CONFIG_FILE and assign the file name you have created.

The predifined delimiters are available as a list Stage->Output->Format properties. The available delimiters are

whitespace
end
none
null
comma
tab

choose tab here. if any thing other than the mentioned above you can directly type the character.

Try to drop the teradata error tables and log table and restart the job. The error table has not been dropped due to previous abort.

a) First Make sure that all your datasets are created with Parallel Option.
b) Make sure that all three datasets has same key and order before passing into funnel stage
c) Instead of Teradata MLoad use Teradata Enterprise stage

Check with do you have an entry "TNSNAMES.ora" in SQLNET.ora file. Since you have modified the IP (server) also check the relative information in your drivers file. Also check your datastage Oracle configuration file (tnsnames.ora).

Environment variables are at PROJECT level and can be used any jobs are sequencers developed under the project, Whereas job parameters are at job level. On top of it you can create a environment variable and re-assign the value at job level.

Eventhough if you have 4 or 8 node configuration, the DS may or may not use all nodes. So the only correct option is to check the monitor while running the job. it shows as stage X 2 or StageX4 etc

add the following syntax in begin and end of your XML.

begin

<ALL>
(this should be the first line)
</ALL>
(this should be the last line)

Reverse PIVOT in datastage is too slow and best way to handle is

a) Push the dataset or data into a physical table
b) write select statement from the table using CASE statement
c) push the result into target

ag_ram wrote:Hi Folks

Is it possible to load data into an oracle table and delete some records based on a certain condition on the same table , and maintain these as a single Unit of work ?

You can create userdefined SQL and place inside the After tab page. This will work.