DSXchange

I am not familiar with that feature. Would it help to use IBM InfoSphere Data Architect? That product is often bundled with other IBM products, like Information Server. Check your license documentation.

Yes, it was one of many surprises encountered!

Our experience with this stage is just beginning. We have it installed and are currently waiting on credentials in order to use it.

Consider joining as a premium member. It costs less than one restaurant lunch per month.

Agreed!

I can comment on two of the items, also about salesforce pack 1.5.0.2, but with IS 11.3.1 on AIX. 2. No entry was created in Version.xml for SFDC pack. "CONFIRMED" - The salesforce pack has its own installer which calls the "dscompinst" program. - I had also noticed there was no ...

Try renaming them and/or moving them to another folder, then start everything up to see what happens.

TZ is Time Zone. Talk to your UNIX Administrator about setting it. It is hard to imagine how not having it set could degrade performance, but I suppose anything is possible.

If the file is consistently formatted as described then you could read every record as a single varchar column with a high length limit (read it as a delimited file; delimiter choice would not matter), and do the columnization within your job design, i.e. substring each column in a Transformer stage.

Your job design or change capture stage settings may be incorrect. Double check those areas. You may also want to review the online help for that stage because "it should output no rows" does not sound correct.

Check in the stage properties for any before-SQL statements. The last time I checked, those SQL executions were counted as startup time.

My question is, do we build individual Sequence for each of these class of objects, like StgSeq, RefSeq, DimSeq, FactSeq to group them togather and then call these Sequence jobs in the Master Seq (Concept of Master and Child Seq) so we segregate them and it becomes easy to add more Dims/Facts in ne...

Yes, it would not be fast, but once you do it, it would be faster each time. It's not like you have to sit and wait for it. Just open it up and check back later. I thought projects had a physical limit of around 5K jobs, so I am surprised you have 15K in a single project. Hopefully you already have ...

We were getting error "du: 0653-175 Cannot find the current directory." when stopping and starting the engine as root. Support said to stop and start it using the dsadm ID according to the doc, and that error went away.

One option is using Director, View menu, uncheck Show Folders, wait for full jobs list to display at once, click a column header such as 'Last ran' to sort by last run time. Assuming you want to delete jobs that haven't run in a long time, multiple select them using Shift or Ctrl and hit the delete ...