Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS
IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE
TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
No Answer is Posted For this Question
Be the First to Post Answer
In warehouses how many schemas are there?
we have to use order by,where,having we to implement sql query
What are different types of transformations available in informatica?
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
what is Partitioning ? where we can use Partition?
Explain incremental aggregation in informatica
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
To import the flat file definition into the designer where should the flat file be placed?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
how can u load the data in time dimension?
How to recover the standalone session?