DSXchange

Hi All, I've been trying to load data through Teradata Parallel Transporter (TPT) stage but every time it fails with following error message TeradataLoad,0: [IIS-CONN-TERA-005029] Unable to continue because another instance encountered an error (CC_TeraDBStatement::dbsExecute, file CC_TeraDBRecordDa...

Thanks for sharing this link

I can understand limiting the information out of log file, and to store only information which is more relevant (rows processed/rejected) but this requires a complete framework of storing metadata inside database alongside data itself. My intention of asking this question was that what if metadata p...

Hi All,

I was interested to know if we can export log against all the jobs under a single project. I can manually save logs against individual jobs, just that it's not practical to export log of hundreds of jobs that way.

Regards,

Saad

Well you can make use of Multiload multiple layouts in this case. You can define all the different layouts in a single script and based upon the value of first 2 characters jump to different labels in the script. One of the limitations using multiload is that import task can do multiple data insert,...

I don't know if there is an easy way but you can simply look out for dependency of the sequence and find all the jobs that have been used through Manager. Then select all the jobs from one folder to other (or put all the jobs in 1 common folder) and keep on exporting it in the same dsx file (by appe...

Ray, you seem to second your thoughts at the moment

I agree with Mike, in most of the cases there is always a calendar table defined for business related queries. You can simply fetch the records from that table joining on the date, this way you'll not need to define the business rule again.

Regards,

Saad

We implemented a similar scenario at one of our projects where we had to dynamically assign a new table for different set of months. The approach we adopted was to call that job through another sequence in which we used to loop around generating the next month and then calling the same job again. We...

Just wanted to update everyone, there is no direct solution to this problem at the moment. May be a patch is required for this by IBM. Anyhow we have implemented a workaround and that is to do the FORMATting of the columns in a view, we create this view in Before-Sql tab, use it in our query and the...

Can you give some more information about your job structure, like it source stages, intermediate processing stages and finally where actually you're inserting/writing data ?

Saad

We're facing a peculiar problem while exporting data through Teradata Connector Stage. The problem is that when we try to enter custom query in the "Select Statement" field it gives warning in a dialog box "Expecting : Symbol of type: row_value_constructor". I tried to figure out...

Kumar,

Try inserting the record simply using Iconv(Input._DT, "DMYD"), actually this generates an internal value which Teradata recognizes and inserts properly. We had been doing this in one of our projects.

Regards,

Saad

Thanks Ray for a very thorough and useful insight. This will definitely help us in our new assignment.

Saad

Ray, Thanks for sharing your views. Actually by 'Review' i mean that we are going to do the Audit of an existing ETL implementation. We would be looking into certain areas as mentioned in my email and then recommending based upon our findings. What I would like to know are other related areas of imp...