DSXchange

I was being facetious, but good to know you got a solution to whatever the issue turned out to be. What is the ECase number?

Or look here - same problem, same day, same solution?

chulett, how would you go about doing that? That is, how would you go about executing the sql from the Datastage server? Let's say it is a UNIX box. You go to the DSEngine folder and then execute the script? Through something like a shell script? Took me a minute to realize what the 'that' was we w...

Yes you can write in an excel using datastage. Just use an ODBC stage. Create DNS driver for excel in ODBC in Administrative tools. After creating the DNS. When you will open the ODBC stage in DS, you can select that DNS and you can link the excel. Keep in mind the fact that this answer is pretty m...

You can also try a couple of other techniques. One is to bulk load your inserts directly into the target table and bulk load the updates into a work table. Then an Oracle MERGE can perform the updates. Another approach is to ensure all you do are inserts. Any changed records can be deleted from the ...

Find any post by Vincent and check his sig. You'll find links back to his blogs and articles where questions much like these very ones are answered.

Don't know TeraData, but it seems the sticky point is this bit: "while in FastExport". Is that an optional something that can be turned off?

IF you can get them to a file, I don't see why you can't write them to a table, what you need is to write a simple Unix script... Or... yet another DataStage job! of course but a lot depends on the format of the output file; point is the file needs to be formatted into tabular form and DS is not al...

Can't you script something via a command line utility and run it 'after job'?

That's ok, admitting a problem is the first step on the road to recovery. Honestly, however, I don't think that is your problem... or at least not the one we are trying to solve right now. An array size of 1 will certainly slow everything down but it won't cause the performance to degrade over time...

ShaneMuir wrote:Pretty sure you have to use sequential files for the Merge stage.

Yes, you do. That's why it asks for Directory Paths and File Names for the two imputs - what made you think a table name would work there, pradkumar?

Keep in mind the fact that you aren't being asked to change it forever, just to see what affect it has on your job.

I thought so too, and would have posted that until I double-checked to be sure. That's when I saw the dots instead of the underscores.

Change / adjust your trigger expressions. Uncheck 'Automatically handle activities that fail'. Fun things like that.

Ok, I guess the confusion (at least in my mind) is the concept of importing metadata from a file that contains the metadata information you need directly versus importing the metadata of a file as you would do via the Manager. Obviously, I went down the latter path. At this point, not really sure wh...