DSXchange

Ask the Support for the Orchestrate API documents, and also for some samples. There are also some samples you can use that are located within the PXEngine directory (on the server, not client).

Do it within a SQL statement.

laprs? Lpars? I am totally at a loss in trying to understand what you're saying here. Are you referring to a different server partition? The Compare stage just simply compare whatever data that are being provided to it from two different sources. Read the help file on it, and the Compare Stage chapt...

May I also pipe in and strongly recommend getting a training class for DataStage. There are some trainers that are very familiar with Informatica and could adjust the coursework to help get you up to speed much faster. Please have your client contact Ascential for training options for you. There are...

In a transformer: ((JulianDayFromDate(TimestampToDate(Input.currentTime)) * 24) + (HoursFromTime(TimestampToTime(Input.currentTime)))) - ((JulianDayFromDate(TimestampToDate(Input.oldTime)) * 24) + (HoursFromTime(TimestampToTime(Input.oldTime)))) This should get you started using truncated hours. It ...

In your Administrator, or your job parameter, you need to define the following environment parameters:

APT_ORAUPSERT_COMMIT_ROW_INTERVAL
APT_ORAUPSERT_COMMIT_TIME_INTERVAL

Enjoy.

You can not do this in EE at this time. Lookup stage pull everything from the reference table before any lookup matching are done. This is vital when you are dealing with parallelism, and the potential for more than 1 matching lookup value at any single run. Each stage are contained in its own unive...

Do let us know if you have any problems with this script, or would like to suggest any feature upgrades.

Thanks.

Rule #1 that many... MANY people do not follow in software development: Communicate with your customer. Whether your customer are your own management team, or some clients, you must insist on ensuring that you and they are on the same page on the value of certain features. It could be likely that so...

As a rule, you must provide a method for DataStage to handle conversion of Nullable values to non-nullable values. Because if you don't, then DataStage will act very funny when it is provided a Null value without any way to handle it. Unfortunately, I can not simply believe you when you said that so...

Within a transformer, convert the decimal to varchar, and trim the leading zeros. Be careful, sometimes the values have negative signs. You will need to work your logic around that.

This is not the problem of the database. It is how DataStage internally hold values in decimal.

Something failed to work. Please provide more details. Especially the warning messages before this fatal errors. Fatal Errors in EE are not the most informative kind of errors. It is the type of errors similiar to listening to a dying man making his final wish. His wish would never make sense unless...

My suggestion: Make absolutely sure you really need to use Server Job routines. There are preciously little that can't be done in EE that is being done in Server. I would restore to creating a buildOP stage before using a Server Job routines. Why? PERFORMANCE! Why do MPP if you're killing your perfo...

Use the column generator stage. Create a single integer column. Open Edit Column Meta Data view (within "Columns"). Choose "Type" under "Available properties to add" Choose "Initial Value". Set value as "part". Choose "Increment". Set value...

Input -> Transformer (make multiple fields - phone[1,2] -> twodigitphone; phone[1,3] -> threedigitphone; et cetera) -> Lookups. With the lookups, use reject links to push non-matches to other lookups. Start with small digits first (as there's less matching obviously), unless your business rules requ...