GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Goldengate date transformation

in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

Hi All,

We are replicating data from Mainframe DB2 database to File writer JSON file format. For this configuration, we are using the remote capture OGG for DB2 and OGG BigData for file writer to write the data into JSON format.

On source DB2 database, some of the tables column are having date field in integer format. We would like to convert the date from integer to gregorian date format.

Source: DB2 version: DSN12015 - DB2 12

Extract: OGG DB2 version: 19.1.0.0.4

Replicat: OGG Bigdata version: 19.1.0.0.2

Logically INT_DT_COL has number of days, these days has to be added with 01-01-1900 to get the actual date.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center