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 the significance of ‘mp run’ command ?
How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC
What is the difference between check point and phase?
What are the various types of layout supported by abinitio?
Explain what is sandbox?
What does edp stand for?
what is macro?At what situation we have to face?
how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio
How co> operating system natively processes the data?
How to create a repository in abinitio for stand-alone system(local nt)?
How to calculate total memory used my a graph?
what is the output when -1 is put in select_expr of FBE?