Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 0 Answers
- 2182 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is transformation?
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
what is semi-additive fact?where did u used?
What is limitations of truncate and load option
Explain in detail about scd type 1 through mapping.
How to identify this row for insert and this row for update in dynamic lookup cache
comonly how meny mappings r there in Banking projects?
what is constraint based load order
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
How can we handle two sessions in informatica?
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
how to declare array in plsql?
Teradata 
