Hai Madhu

thank you

Please send some examples how to Validate in GL interface

What is Validation?

Hi

Before the data gets inserted in the actual database table the data gets validated...

by validation i mean there are two files created called bad file and discarded file......first validation occurs in the bad file and second in the discarded file....data in the discarded file is discarded and finally the data is entered in the database table......

Please correct me if I'm wrong....since i'm a beginner .....i may learn more if you correct my mistakes...

thanks

Preethi

Hi

the basic need for a staging table is to serve as another step before loading into the interface tables after which we run oracle standard APIs to load them into the bas tables sometimes even after running APIS we may need some concurrent programmes to be run so for that data to be reflected across the base tables. The staging area serves for updates like date formats (MM-DD-RRRR) and other such critical data format changes neede before we load into interface tables and then running APIS in them . As explained above a bad file if formed while loading if some data format is not in consonance with the API or base file and hence the whole API/validation fails In some case though it creates a corrupt log file which also indicates the failure of the validation.

Plz correct me if I am wrong.

these staging tables are used to hold temporary data i.e data with in the temporary table will be automatically get deleted when we issue commit or when we close oracle session that depends on how we create table

eg: create global temporary table eg1(name varchar2(20) num number(10)) on commit delete rows;

this will delete the rows on temporary table when we issue a commit at sql prompt.

moreover these staging tables are used to do some primray validations before inserting data into actual tables.

so we need data to be erased after inserting into acutal tables. so we go for staging tables.

we can use normal tables also as staging table but we need to truncate table for each insert. thats why we go for temporary tables.