hi in which phase of mload can i use .FILLER
Answer / sajith
When your data file has additional columns comparet to your
target table, you specify "FILLER" against the attribute
against the control file and the same will not get loaded
Is This Answer Correct ? | 0 Yes | 0 No |
what is the use of foreginkey
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What is a join and explain different types of joins?
what is Normalization?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
What is an application role and explain a scenario when you would use one?
How to replace not in with not exist?
What are the types of database model?
Define candidate key, alternate key, composite key?
30 Answers IAS, IBM,
What is denormalization and when would you go for it?
Write short notes on manual refreshes.
agregator gives one to many records or many to one record