DSXchange

Two different questions combined here 1. There are four parallel jobs in a folder and I am trying to delete from the designer and it throws following error Error message: Unable to delete the item(s). Delete object for '\folder1\folder2\myJob' failed. Cannot find job myJob 2. How to change the refre...

Thank you for suggesting the work around. That was helpful. FT seems to be a great tool to quickly develop DS jobs

Thank you for the response. That is what I ended up doing. The only issue is that it breaks the mapping in the copy stage which was already taken care in the generic stage. The mapping breaks because the column names in target is different from source columns due to the naming standards. Auto match ...

Is there a way to model generic stage as copy stage? Sorry I am not too familiar with orchestrate scripts. Is there a documentation with examples? I could not figure this out from advanced developer guide

There is job that I generated from Fasttrack. The job doesn't have much transformers except for few (4) lookups from dimension tables. The job that is generated looks as follows and seem like will save time and manual work. Src Tbl > LookupContainer001 > Transformer > MappingContainer > Target Looku...

Update I had another etl server with 11.7. Fast track client opened initially. I imported the fasttrack export of 11.5 ( which was also imported in the other 11.7 server before upgrade). After the import, I cannot open 11.7 client now. Something is happening to 11.7 client once the FT assets are bro...

We upgraded one of the etl server from 11.5 to 11.7. Since then we are not able to connect to fasttrack client. We get the following error: Server Registration failed. But we are able to connect to other clients such as director, designer etc So I tried to export fasttrack asset using ISTOOL and I g...

Trying to create a lineage report. I have two jobs, job1 loads data from tab a to tab b (kind of staging job which is 1 to 1. Then job 2 which takes the data from tab b and loads into tabc. This job reads data from tab b does a bunch of lookups and pass the data through tx stage before loading into ...

The transformer is set to auto. So if 'hash' or 'modulus' is selected in Agg stage then the same partition type should be set in the transformer? I will change the settings and report back.

Thanks

Yes the job is executing on 6 nodes with all the stages running on the same nodes. In this eg, the upstream stage is a transformer stage. The input stage is a Oracle stage where partitioned read is enabled (with default rowid range). The group is performed on Year(kind of redundant because we only p...

Thanks. It worked. Earlier, the sort order was different than order of group key column. I selected partition type 'Same'. I am not sure what it means. 'Auto' and 'Entire' didn't work. What is the recommended partition type?

Is pipe-lining possible when aggregator stage is used. For instance, I have a job using aggregator, that sums up colD by grouping 3 input columns, ColA, ColB, ColC, so before aggregator start spitting the rows out, it waits for all the input rows to be read. Is there a way to make aggregator stage p...

I figured this out. I was following IBM KB which was not correct for enabling this at the project level. It worked after I set the value (path) $APT variable and specifying this in the job

Will enabling this for all the jobs degrade the performance of ETL during the batch load?

I am new to DS. I do not know how to use it. I bumped into this tool within director which seems to have a set predefined reports on the data it collects in a directory indicating the performance of each stages and (nodes?) in the job. I would like to enable the report for the few jobs that resource...

I wanted to enable record performance data to view the performance data as a graph using the tool in director. To do this I went to DS designer client, opened the job I wanted to collect the stats, under the job properties/Execution tab added the following line under Advanced runtime options: -padd ...