DSXchange

What if the data was already partitioned, will the join automatically repartition it by my join key? For example. Suppose I have 2 Sequential file inputs which are linked to respective datasets using hash partitioning on key1. Then in second job I have these two datasets as inputs into join stage an...

Hello Forum,

Is it possible to have a parameter to shared container that has a default value? There does not seem be be an area in the container properties section to set this.

Thanks,

Greg

Hello Forum,

When source is sequential file and I pass this through a transformer with default partitioning methods specified ie 'Auto'. What exactly is done. Is round robin method used, or does it perform hash partitioning by the key fields from my column metadata?

Thanks,

Greg

Update: It appears that the Basic Transformer does not access job parameters reliably when in a multi-instance job. In some cases if the job had not been run yet without an invocation id, all parameter references from the job with invocation-id are assigned empty string. In my particular case I was ...

Hi, Can you concider a work-around like storing all Emails in a table and having a periodical process go over it and send the emails? (you can have a DS job that rund every hour,30 minutes or any other interval you need and send the enails) IHTH, Thanks for your response. That solution would achiev...

Hello Forum, I am running a Parallel job that contains a Basic Transformer. This basic transformer is calling DSSendMail. I have observed several strange situations when using this as a multi-Instance job: 1. The emails sometimes fail to be sent out. A network error appears consistent with the send ...

Is it pure coincidence the the premium content button is shaped and colored like a greenback?

Now that we have these Premium Content advertisements, maybe we can start a countdown of active datastage users from


Free Content Follows:


10000 to 0.

Good feedback, thanks. Is someone going to report this anomaly (and problem) via their support provider? If so can you please post their response here? Enhancement request is tracked under 87666. Their response is that if the following query returns no rows, then the table is considered not writabl...

Hello Forum, I have also experienced this error while using the Teradata Enterprise stage. I solved by explicitly granting an insert privilege to the table in question. Interesting part was, that even while getting this error, I was able to load using an Teradata API using same ID and password. I'm ...

Hello Forum, What are the feasible/preferred methods of calling a Teradata SP from DataStage Server job? Given that Teradata SP do not return more than one row, I am inserting the result set from the SP into a temp table, and then I had the intention of both calling the SP and selecting from the tem...

Hello Forum, What are the feasible/preferred methods of calling a Teradata SP from DataStage? Given that Teradata SP do not return more than one row, I am inserting the result set from the SP into a temp table, and then I had the intention of both calling the SP and selecting from the temp table fro...

Hello Ray, Thank you for your response. My client is using Teradata, and is discouraged by the performance of the Teradata API stage. They are using the API stage in some situations where they are not using MultiLoad because of some extra indexing requirements required by that stage. A improvement i...

Hello Forum,

How does one go about creating their own Plugin in DS? Is it feasible? Where is the procedures/interface documented? Does anybody have experience in doing this?

Thanks,

Greg

Hello Forum, I receive the an error after doing the following: Table Definitions->Import->Stored Procedure Definitions->Ok->Import DSR.MetaGeta(GET.PROC.COLUMNS)(SQLPrepare("{CALL "DQ_CD_INSERT" (NULL,NULL)}")): BCI Error: SQLSTATE=S0002,CODE=-3824,[DataStage][SQL Client][ODBC][N...