CODEWITHSUNDEEP
asciiinformaticamainframeebcdicinformatica-powerexchange
PythonDeveloper
PythonDeveloper

Reputation: 404

How to load EBCDIC file into relational tables ( Oracle, SQL Server etc.) using Informatica Power Center

I have a mainframe source file in EBCDIC format. I need to load it in Oracle database . We also have Informatica Power Center and SSIS ETL tools.

What is the easiest way to load it in relational tables using or without using above tools? How to decode this file?

Note- when I open this file, I see all weird symbols ( this is a text file but in EBCDIC format so I can not understand any of the data in this file). It's a sequential file and I also have a Cobol Layout file along with it.

Upvotes: 0

Views: 909

Answers (0)

Related Questions