Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ?
I mean wat is the point of pointer update in data dictionary?
No Answer is Posted For this Question
Be the First to Post Answer
What is data encoding?
What are the different String functions used in Abinitio?
List out the file extensions used in abinitio?
What are the primary keys and foreign keys?
Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?
What is the significance of record required indicator of Join component ?
Name the different type of processing based on the steps that you know about?
Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999
How transaction file different from that of a sort file?
what is the difference between ab_work_dir and .work
what are the steps in actual ab initio graph processing including general,pre and post process settings?
Within a cursor, how would you update fields on the row just fetched?