DSXchange

By using entire partitioning on reference link (expected to be less data than stream link) it eliminates the requirement of repartitioning the input stream link data, and to answer you question, Yes, it insert entire partitioning on reference link by default and entire partitioning ensures that you ...

did you verify the permissions on configuration files?

Then first check if question mark if there if you create a local file as well. Or if there is an unprintable character in the beginning.

The details from SystemOut.log is very less, we generally need to see a lot of those lines and mainly a few hundred lines when the problem first occurred. Without that, we are just guessing. So a few questions 1) Are you on internal registry for authentication or OS/LDAP authentication is used? 2) d...

I am not sure if I understood what is being asked, please correct me if the answer seems off topic. You can have multiple engine tiers connected to same service tier. So when you login you will have to use service tier IP and port and then in project dropdown you can find the projects as "hostn...

I think you have your answer. And even in case of abrupt failure, the job related information is saved in &PH& folder in project directory. These files only generated when there is a connector stage in your job which failed abruptly, IMO.

Why don't you just add descriptions to one job, export it and then confirm the location of short and long description in dsx to modify?

Don't have access to check so need to ask whether you have any content in those files or they are just 0 byte files?

then please reset your job and then let us know the content of log entry similar to From Previous Run(...)

Also, please do check that if any warnings are demoted or suppressed.

It will partition the data if you have auto partition and APT_NO_PART_INSERTION environment variable is not set.

Any other warning or error?

In oracle it can be defined as Varchar2(10 char) and NLS_LENGTH_SEMANTICS also plays a role there. The string you posted in there has 11 bytes, If changing length that it not possible, how are you planning to accommodate 11 bytes to a 10 byte field?

Read about having a junk dimension as mini dimension of profile table. If its dimension star schema then I think its better to have that linkage through fact table instead of a mini dimension or an out-rigger. So have a SCD type 1 dimension with all the codes (junk dimension) linked to profile dimen...

qt_ky wrote:And Craig's "more better" slides by?

He already suggested a better approach than his last approach which may not be the best, hence "more better"

PS: it just fell shy of being much better

but why not update the same functions rather than using a new one?