Interested to Buy Any Domain ? << Click Here >> for more details...
One of the optimizing technique to improve the session
performance is push down optimization,by using push down
optimization we push as much as transformation logic to
source/target database,but this degrades the d/b
performance,how to overcome this?
- 0 Answers
- 2250 Views
- TCS, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
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.
guys which is the best institute in banglore to learn informatica??
What are the join types in joiner transformation?
what is the need of session partitioning... how it is useful in real time
What is partioning?how many types of partinings are there
major difference between normal loading and bulk loading?
differences between service based and product based?
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
What are the basic needs to join two sources in a source qualifier?
What are the different components of powercenter?
what is persistant cache in which situation we will use persistantcache
Teradata 
