DSXchange

kirankumarreddydesireddy wrote:We wanted to know if this feature "Salesforce Pack" is available for Parallel jobs only

Yes.

It was changed in the database or just in the job? Honestly, I have no idea why you are seeing what you are and suspect it will take 'boots on the ground', eyeballs there to figure it out. What do you get if you select DUMP(YourColumn) from YourTable in Oracle? Have you involved your official suppor...

I've had the exact same problem. Searching for something I know is out there somewhere can get drowned out by posts that just say to search for it. I usually try to give examples of what to search for and/or post an example of what I found.

I have tried to learn about ODBC stage and its option (like Insert Array Size, Fetch Array Size, Row Commit Interval etc.,). But i don't see this stage in any manual. If anybody knows where i can found more info on this, please let me know. Meanwhile can you explain what is the difference between '...

karthi_gana wrote:I have also seen APT_RDBMS_COMMIT_ROWS environment variable in the below link.

http://etl-tools.info/infosphere-datast ... iables.htm

I don't see this variable in my project. !!! ???

Add it.

karthi_gana wrote:

Note: ODBC Connector is the preferred stage type for ODBC.

can you tell me why?

Connectors are the way of the future and are thus preferred across the board. All other stages are deprecated, which the documentation clearly states.

Sounds like it may have been converted to the word 'NULL' rather than a true null value.

True... between the capabilities of BASIC routines and leveraging hashed files, you should be able to handle whatever needs handling.

Need to? No, it doesn't sound like it. I would imagine you simply entered the name of the variable incorrectly in that one job. Overall, the use of those tokens like $PROJDEF is certainly a best practice but you'd have to decide if it is worth the time and effort to change it across all jobs.

Token variables? If you mean ones like Ray listed, those three are it and you can find them in Client Guide for the Director or the Designer. If you mean all of the $APT environment variables, I don't recall seeing a manual where they are all listed but you can find them in any job's properties when...

Yes, add $APT_DUMP_SCORE to the job and set to true.

dsqspro wrote:I agree "reconcile debit and credit" should be topic heading

Then please, by all means, go back to that first post and edit it to reflect this subject.

qt_ky wrote:8.5 and higher offers looping in the Transformer stage.

Out of curiousity, is that true for Server jobs? For some reason I though just Parallel ones supported that.

Which is what a search would reveal.

How about searching for that message and seeing if any of the existing posts help? Just "cannot preserve the partitioning" should be enough.