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?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
i have 2 session s1 execute s2 load first session fail what is the reason?
How many repositories can we create in Informatica??
what are the deliverables?in your project?
i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
how can we calculate fact table size?
How do you change a non-reusable transformation to reusable transformation?
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
waht type of interface is used for testing the data in informatica