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

what is the difference between stop and abort?

3 Answers   TCS,


what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?

1 Answers  


what is difference between dimention table and fact table?

1 Answers  


How you count the number of records available at your source?

3 Answers   Zensar,


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  






When the informatica server marks that a batch is failed?

2 Answers  


What are the tasks that source qualifier performs?

1 Answers  


scd methodology?

2 Answers  


What are the designer tools for creating transformations?

0 Answers   Informatica,


Write the unconnected lookup syntax and how to return more than one column.

0 Answers  


Why should we use star schema in datawarehouse design?

2 Answers   Wipro,


What is rank transformation in informatica

0 Answers   Informatica,


Categories