What Is The Difference Between Default Column And Fixed Column Parame

1.	What Is The Difference Between Default Column And Fixed Column Parameters?
Answer» DEFAULT COLUMN specifies a default value for an EIM column and it is USED only when the column is null in the EIM table WHEREAS FIXED COLUMN specifies a fixed value for an EIM column and the fixed value gets loaded in the base table OVERRIDING the value in the EIM table column. DEFAULT COLUMN specifies a default value for an EIM column and it is used only when the column is null in the EIM table whereas FIXED COLUMN specifies a fixed value for an EIM column and the fixed value gets loaded in the base table overriding the value in the EIM table column.

What Is The Difference Between Default Column And Fixed Column Parameters?

Answer»

DEFAULT COLUMN specifies a default value for an EIM column and it is USED only when the column is null in the EIM table WHEREAS FIXED COLUMN specifies a fixed value for an EIM column and the fixed value gets loaded in the base table OVERRIDING the value in the EIM table column.

DEFAULT COLUMN specifies a default value for an EIM column and it is used only when the column is null in the EIM table whereas FIXED COLUMN specifies a fixed value for an EIM column and the fixed value gets loaded in the base table overriding the value in the EIM table column.

Discussion

No Comment Found

Related InterviewSolutions

What Will Happen After Processing If There Were Two Duplicate Records In The Eim Table?
Can You Enumerate The 11 Steps For Eim Import Process?
What Is The Difference Between Default Column And Fixed Column Parameters?
Why Using Synonyms = False Parameter Is Highly Recommended For Eim Performance Tuning?
What Is The Purpose Of Session Sql Parameter In The Ifb File?
What Does Include Parameter Mean In An Ifb File?
In The Ifb File, You Have Mentioned The Credentials For Database Incorrectly But The Proper Credentials Are Stored At Srvmgr Level, Will The Job Throw Any Error?
What Is The Difference Between If_row_stat And If_row_stat_num Columns?
How Will You Identify The Corresponding Eim Column For A Particular Base Table Column? Say For S_prod_int.name, Explains?
Explicit Primary Mapping Does Not Occur In Each Eim Table Mapping. In Which Case Can You Find The Explicit Primary Mapping Defined In The Eim Table Mapping?