Thursday, March 29, 2012

Informatica Questions from a friend - Part 1

HOW TO USE A COBOL FILE FOR TRANSFORMATION
 
Informatica allows reading data from cobol copybook formatted data files. These files mostly 
come from mainframe based source systems. Given that many of the world's leading business
systems still use IBM Mainframe as their computing systems, e.g. airlines, banks, insurance
companies etc, these systems act as a major source of information for Data warehouses,
and thus to our Informatica mappings. 
For using a cobol copy book structure as a source, you'd have to put that copybook in a 
empty skeleton cobol program.
IDENTIFICATION DIVISION.
PROGRAM-ID. RAGHAV.

ENVIRONMENT DIVISION.
SELECT FILE-ONE ASSIGN TO "MYFILE".

DATA DIVISION.
FILE SECTION.
FD FILE-ONE.

COPY "RAGHAV_COPYBOOK.CPY".

WORKING-STORAGE SECTION.

PROCEDURE DIVISION.

STOP RUN.

The copybook file can by a plain record structure.
Read more about defining copybooks around here.
 
 
 

No comments:

Post a Comment