DSXchange

Hi Arasan,

Post this topic in Server forum and use the Search facility.

It has been discussed a lot many times.

You can remove duplicates by loading into a hash file, by using stage variables in Transformer.

HTH
--Rich

Hi Nagesh,

Use Option 1. Changing the metadata is always better(eventhough it is going to take some time) rather than introducing a new stage.

HTH
--Rich

Hi, What is the partitioning type that you are using for your dataset, copy and teradata enterprise stage. The problem seems to be somewhere here main_program: Fatal Error: There are irreconcilable constraints on the number of partitions of an operator: parallel Teradata_StrTransfer. The number of p...

Hi Ravi, Due to network problems I could not connect to Datastage(via Citrix). Just gave the reply from the back of my head. I usually don't reply without working on the problem using Datastage but yesterday I was just curious to see the charter member logo against my name. Sorry if I mislead you. N...

Hi,

From the command window in Datastage Administrator execute the following query.

SELECT DTM, MODFIFIER FROM DS_AUDITS WHERE INSTANCE='Job_Name'

It will give you the creation as well as the modified time of the job.

HTH
--Rich

Hi royhhlai,

I dont think you can create a column with null value but you can use make_null orchestrate function and set null value for any incoming column.

input_column = make_null(output_column, 'XYZ')

HTH
--Rich

Veni,

Use the Routine Activity Stage with ExecSH routine and rm command.

HTH
--Rich

Hi,

1. Have you used the View Data option in OCI.

2. Load the metadata from Datastage Repository. Usually it is Timestamp 38.

Pls let us know what happens.

Rich

Hi Poornagirija,

Its been a long time since I did this but I remember using the ODBC stage and had the Include System Tables option enabled after which I was able to access each worksheet as a seperate table.

HTH
--Rich

Hi,

Just do a search for SCD in this forum. Just a week ago we had a discussion with regard to SCD.

Search is available at the top, next to the forum link.

HTH
--Rich

Hi Akaash,

Just in case you are not aware - You can edit your orginal post.

HTH
--Rich

Hi Kumar,

Did you mean where to use or how to use.

If you meant how to use then it should be be

GetEnvironment('USERID')

HTH
--Rich

Hi Rafiq,

I think the problem might be with the link ordering in Change Capture stage. As Arnd suggested write the output of the CDC to a peek stage and check the value for change_code column. If the results are reversed then the link order should be changed in Change Capture stage.

HTH
--Rich

Hi,

I may not know the answer but I know how to get the answer - By using the search functionality. :D

Look into this post.


HTH
--Rich

Hi,

Use the search option and do not mention urgent. You probably not have your questions answered by mentioning urgent.

HTH
--Rich