How To Generate CSV File Output As Header Contains All Column Names And Then All Column Data Formatted By Delimiter
(Doc ID 2926453.1)
Last updated on JULY 20, 2024
Applies to:
Oracle GoldenGate Big Data and Application Adapters - Version 19.1.0.0.10 and laterInformation in this document applies to any platform.
Goal
Configured goldengate adapters version 19c for generating CSV file using java adapters.
In CSV file output generated by goldengate having records as column name and delimiter than column data. Where as we need to generate
output as header contains all column names and than all column data formatted by delimiter. Also at the end specify number of records.
Request Format:
Start_Dt|test_xxxx|OXXX_XX|XXXXX_Brand_XXXX|Customer_XXXXX|FXX_XXXX|Data_Source_XX|Test_Attribute_1|Test_Attribute_2
2022-03-28|432|602472222||115223.31|XXXX||Test_Attribute_1|Test_Attribute_2
2022-03-28|593|1743844466||14014.79|YYY||Test_Attribute_1|Test_Attribute_2
2022-03-28|696|1496845645||55354.03|XXXXX||Test_Attribute_1|Test_Attribute_2
2022-03-28|741|489333333||93381.47|YYYY||Test_Attribute_1|Test_Attribute_2
2022-03-28|912|1375555555||110037.89|ZZZZZ||Test_Attribute_1|Test_Attribute_2
T|2022-03-28 10:42:34|5
Where as Goldengate generated format is:
"I"|"TESTGG.TEST"|"2022-12-01 11:10:05.000653"|"2022-12-01T11:10:11.005000"|"000000000400000027XX"|"XX"|15|"NAME"|"XXXXX"|"MONTHLY_XXXX"|100.00|"LAST_TEST_XX"|1234
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |