DSXchange

I guess you are referring to "Timestamp string" under the "Defaults-TAB" of Job Properties? This has the regualr timestamp: %yyyy-%mm-%dd %hh:%nn:%ss I tried to change this, but didnt help. Which APT variable has the default values for PX for INT or TIMESTAMP. example: In a looku...

I have a job which is trying to read some datasets(DS) and writting to a table. Data Flow is: (RCP enabled, using schema file in CE/CI) DS --> COLUMN EXPORT(CE) --> TRANSFORM --> COLUMN IMPORT(CI) --> DB The datasets are created by a different flow(say JOB#A). The dataset has a timestamp as one of t...

In custom Buildop I am checking for a condition.

Is there a way to write a custom message(string) depending on a validation?

Message should go to the director log.

Thank you for your feedback.

the script might be done for old DSX versions, not sure if something changed in new ones or the version of DS may effect it.(8.0 was buggy without patches)

Wanted to know if there is way to do this in 8.0.1(PX) Or is there any routine or function we can write to to change the metadata table def's used. I remember doing this in server, you can write small basic code and change the table def's definitions. Also, how is the table definitions liked to the ...

PS: I have looked at the post already. Want to know what the documentation means that the links to db will use Purpose Codes. I would want to do my Updates first and then my inserts on the target. The business key is always null for updates, so i am using this to split inserts VS updates, as I am no...

As per the IBM documentation: Updating the dimension table Purpose codes are part of the column metadata that the SCD stage propagates to the dimension update link. You can send this column metadata to a database stage in the same job, or you can save the metadata on the Columns tab and load it into...

Yes, it did for what ever i tested - might need more rigourous testing.

Yes, oracle table field is non-nullable.(table mn_org_340b, NUMBER(20)) Oracle def is taking presidence. If I put a NVL it comes fine. Imported metadata with orchestrate table def sql is: select mm.REL_MARKERS as Mem_REL_MARKERS, mb.org_340b_ID as ORG_340b_org_340b_id, mb.grant_code as ORG_340b_gran...

I did search the forum. Issue is its writing these zeros to DS, flat file. When I load this data to oracle db, its fine. I am doing a CDC using SCD on this data loaded in db and incoming source data. Will it impact the lookup. Also, when I write this data to a varchar field, it holds on to zeros. Is...

-Pulled in metadata using orchestrate method in table def -intiger came in as decimal(38,10) -when data flows through these fields, its padding zeros(0) in the front. example: oracle db has intiger 101 DS is reading as "000000000000000101" (lots of zeros) Any reason this is happening? Any ...

I am also getting this when i use "VIEW data" In OSH its defined as, ORG_340B_ORG_340B_ID:nullable decimal[20,0]=ORG_340B_ORG_340B_ID; I checked all the places where I am using that column - its nullable. Is it holding on to something??? ( i closed many times/saved/exited) I also went to t...

While using oracle EE stage, my job is : Oracle ee(read) --> Transform --> oracle ee(write) In the (read) side, I have user defined sql, with left outer join (Tbl A left outer with Tbl B) There are rows where I get nulls in Tbl B. I get the following error : Fatal Error: Attempt to setIsNull() on th...

FYI, the 2 duplicate post are not intentional, not sure how it happened.

Can admin clean it up?

Did you try to figure this out, I am having the same issues, it reverts to DB2, even after using ORACLE.
Is it a bug?