DIFFERENCE BETWEEN FLOAT AND DOUBLE DATATYPES

The main difference between Float and Double is number of decimal points they store after precision.

1. Double will store more values (15 - 16) after precision compared to float (7).

2. The performance of double is less compared to Float.

INTRODUCTION TO PYTHON

Python is high level programming language it was developed by Guido van Rossum in Feb - 20 - 1991. The name was taken from the famous BBC program Monty's Python circus.It is platform independent i.e., it can be run any where.

Python is functional programming,object oriented,modular and scripting (not compiled only interpreted)  language.

Uses of python:

1. Develop desktop applications i.e., windows applications ex: Calculator,excel etc..,
2. Develop web applications using Django framework.
3. Develop database applications.
4. Develop networking applications.
5. Develop games.
6. Data analysis (data science).
7. Develop Machine learning, AI and IOT applications.

Limitations of Python:

1. low Performance since it is interpreted(read each line at once) language.
2. It is not suitable for large applications.
3. It is not suitable for mobile applications.

 

HOW TO LOAD DATA FROM FLAT FILE CONTAINING COLUMN LENGTH GREATER THAN 4000 CHARACTERS USING ORACLE DATA INTEGRATOR( ODI)

ODI default flat file string length is set to Varchar2 (4000 char).

To Load the data of column having more than 4000 characters, we need to change that to CLOB by following below changes in ODI.


     1.  Go to Topology Tab-->Physical Architecture-->Technologies-->File-->DataTypes
     2.  Go to String  Open "Converted To" tab and change the datatype to CLOB and save.