DSXchange

Make sure

Before and after datasets have identical layouts.

In the input tab of your Change Capture stage you have used the same partition on the same partition keys. Also your sorting keys are the same and in the same order.

See Ernie's post on this. You can see that HERE

If you do not validate the document against XSD schema does this error appear? Is this happening only for this job or are you getting this error message in any other jobs? (Can be space/buffer/cache related). Set APT_DEFAULT_TRANSPORT_BLOCK_SIZE to the double of maximum possible message size expecte...

Check in the Administrator if you have specified a config file as value for $APT_CONFIG_FILE. Check if there is a similar parameter specified as user defined parameter in Administrator. If $APT_CONFIG_FILE is specified in Administrator and that is the config file you want to use, you can set the job...

Your dsenv file should have the path of shared library set to $APT_ORCHHOME/lib and also you must have APT_CONFIG_FILE set (Pointing to the same configuration file you used to create the Data Set). Then run the orchadmin command

cd $APT_ORCHHOME/bin
orchadmin rm $Path/FileName.ds

I think the same topic is available in FAQ section by the same Author (Vincent).
Refer this LINK

As noted, you can compare dates or timestamps directly.

Date1=Date2

or

Timestamp1=Timestamp2

If they are different you will get the Status:0
If they are same you will get the Status:1

Rajesh_kr82 wrote:I have two timestamps and i want to compare them in a PX job.

In the filter option put the below code

Oops typed it wrong. As noted, search should be on 'vertical pivot'. Link I posted previously should give you the solution.

Do a search for 'horizontal pivot' and 'horizontal pivot' in the forum. Refer THIS link especially for similar one.

No, because join stage expects all the input links to have the same column name/s to consider for join key/s. Rename to one common name from one of the previous stages or as noted earlier introduce a new stage like copy stage for renaming. If any database stages are involved use alias. join using jo...

Code you specified also is finally making a string, so if you just want to modify , you can use substring function TimestampToString(StringToTimestamp(from_funnel.EFCTE_CLCLD_DTTM, "%yyyy%mm%dd %hh:%nn"), "%yyyy-%mm-%dd %hh:%nn:%ss")[1,10] or else rewrite the code with conversion...

So that confirms this is a conversion related issue only. If you are extracting from the same table and some jobs are running fine, what differently are you using in the failing jobs? A different target table with different datatype? You are converting Char to decimal and then to integer, trim the s...

APT_ORA_WRITE_FILES will allow you to specify a file (not a directory) from where you can execute sqlldr. The post referred above was later discussed in another thread and clarified.
Pls. find the same HERE

DSguru2B :

Checkout csrazdan's reply in this post.

Yeah, modify stage dosen't like job parameter substituted in its operator calls.

JoshGeorge wrote:Substring syntax looks alrite for me.

OutputField=substring [startPosition,len] (InputField)

or is this not the right syntax? Passing job parameter into that syntax can be the issue?[/quote]