DSXchange

A couple of suggestions. 1) Make the Command "/Folder1/Folder2/Filename.ksh" and leave the Parameter part blank as you are not passing any parameters to the script. The 'ksh' command bit really shouldn't be needed, especially if your script is properly written. 2) Post the script, wrapped in Code ta...

No, I think you used the correct word for what you are doing and the questions you are asking. None of this is 'normal ETL' except in a very loose sense. I've been using the product since version 3.1 and have never needed to ask the questions you have been asking. And your source isn't just 'univers...

Talk to your SA - a System Administrator. Have them double-check that all of the kernel parameters have at least the minimum values for your O/S as noted in the Installation and Upgrade Guide pdf. This rather than solving this one parameter at a time. Unless you've already done this when the product...

It's not... and unfortunately you have just strayed into the DBA Woods, sometimes also known as The Forest Of No Return. $ oerr ora 12535 12535, 00000, "TNS:operation timed out" // *Cause: The requested connection could not be completed within the timeout // period specified by the CONNECT...

Bottom line is you sure seem to be blowing some kind of limit... and fixing one may lead to the other blowing as well. Keep both in mind (OS and DB) as you work this.

I for one have always wondered what the motivation was behind all of these questions and have purposefully restrained from chiming in at all before this point. I mean, come on... this was more than the small amount of dog paddling some people do in the shallow end of the UniVerse pool looking for le...

Not need to copy & paste unless you are a masochist. All your metadata is there, why not just 'Save' then 'Load' inside the Sequential File stage?

Sure... possible.

Land the output of DSLink_50 to a flat file, then pick it back up from there before going on to Mr Black Circle.

ps. Be careful of the popups on that site, I just got one of those bogus 'Security' warnings.

If you run them separately, do they run without this error? Edit - nm, I see you already said they did. To me, that would imply you could have overloaded your database. There is typically a parameter that controls the number of maximum concurrent connections, perhaps you've blown that limit? A DBA s...

@OUTROWNUM gives all the row numbers as a seperate column, but I just need the total number of rows in a column. Then again I have to plugin a AGGREGATOR to take the last value of that column ( and this does not work with the constraints I am giving). I'm sorry, but this makes absolutely no sense t...

Sounds like you may have promoted the wrong version. How did you pick the version to Promote? Manually or via the 'Initialize Batch' picker?

Also check the Long Description of the job in Dev versus Prod - Dev may say 1_3 and Prod may still say 1_2, for instance.

Using VersionControl I promoted it up a test layer, where it failed. When the sequence ran it didn't include the new job parameter when calling the job, so the job defaulted to its default value for the parameter, which in the new layer is invalid. Can you go through the steps you performed? I don'...

Not sure why you would do that when it is exactly the same as the provided System Variable @OUTROWNUM.

As noted, we'd really need to know the 'why' behind the 'what' - why are they doing this and what do they plan doing with the number? That knowledge will help get them a proper answer.

So what i thought was that, if i can some how change the target file name which is given as a job parameter, at run time in a transformer then whenever the parameter is set the new file name will be there and hence a new target file will be generated. Just in case it was not clear in the previous p...

Yup... that's where I would have pointed anyone.