DSXchange

Hello All,

Thanks for all your inputs. Looks like they have changed the TNS in the head node and forgot to change in the compute node.

When he fixed that... all is well now.

Thanks for you valuable time.

Yes, they all have been updated.

When I am saying "View Data", I am not changing any credentials. The parameters are defined as $PROJDEF so it should be getting from whatever we defined in the administrator. In short, it is using the same credentials to connect to the database. As far as the user, who is running the job f...

It is in the same environment. Me as the developer trying to do both.

"View Data" worked. Run the job failed.

Hello Gurus, I am moving from one DB to another DB and I am using environment variables for server,user,password and schema. Admin updated the tnsnames.ora with the new connection. Updated the environment variables with new DB details. When I open a job and do View Data, the connector is able to con...

Thanks Chulett and Ray.

I cannot see anything that Ray wrote as I am not a member. Hopefully the members got some benefit out of this conversation.

Thanks anyways!

Okay. I haven't done this before. Can we write something outside of the Datastage (or within a datastage) to go and collect the start and end time for the latest run of every sequence within the project? Can someone share a sample with me?

Thanks in advance.

Exactly... there is no after-job subroutine's within the Sequence. Ray, adding the Rotuine Activity within the sequence cannot help me to capture the EndTimeStamp of the sequence as technically the sequence is not complete until after the Routine Activity is completed. Isn't it?

Thanks

Hello Everyone, We have created an after job sub routine, which would get the details like runtimes, record count, cpu... into a file, which will be later loaded into a Teradata table for analysis. This routine is called in all jobs in "After Job Subroutine". The question is, how can I cap...

Thanks Chulett.

You are suggesting to use the IsValid function in the Transformer, right? I was trying to avoid transformer for the performance reasons.

or the Transformer isn't that bad for this functionality? I am expecting about 500 million records as input.

Thanks

Hello All,

Are rejects possibile using the Modify stage? I am planning to convert the columns from string to integer using the modify stage and I wanted all the rows that fail to convert go into a reject file.

Please assist

Kishore

Thanks for that assistance. Yes, as stated I checked already on the distribution and unbalance AMP's. It is prettly evenly distributed as it can be. The table is a set table and the API stage is doing the upserts based on the key. Yes, I have been working with the DBA's on this one and it doest not ...

I have searched on the topic and none of them kind of answered my question. Please assist.

Hello Everyone, I am reading from a text file into a transformer, where I am defaulting a couple of columns to null (SetNull()) and one other column to CurrentTimestamp() which then flows to Terada API stage to do Upserts. On any given day, the number of records in the text file are not more than 50...