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
- 2216 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
can we use bulk loading when we use look in mapping
Under what condition selecting sorted input in aggregator may fail the session?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
What are junk dimensions?
Explain reference cursor?
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
is it possible to index the data in cache of lkp transformation ?
How do you load first and last records into target table?
What is Data Caches size?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
Teradata 
