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

Post New Answer

More Informatica Interview Questions

Hi experts, can anyone tell how much we use plsql in real time

3 Answers  


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

0 Answers   Patni,


can anyone explain me about sales project in informatica?

8 Answers   MBT, Satyam,


how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,


what is mapping performence?

2 Answers   Cap Gemini,






can we import source table without using source qualifier? if yes then how? if no then why?

2 Answers   Thomson Reuters,


Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,


How to compare Source and Target table, without using dynamic lookup?

4 Answers  


 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,


Differentiate between mapping parameter and mapping variable?

1 Answers  


what are presession,postsession success and postsession failure commands ?

1 Answers  


what is difference between dimention table and fact table?

1 Answers  


Categories