Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

Target increases every day even though no new record was inserted

0 Answers   Accenture,


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?

3 Answers   IBM,


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

0 Answers   IBM,


following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

4 Answers   TCS,


What is the difference between informatics 7x and 8x and what is latest version?

0 Answers  






Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 Answers  


what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,


How do we implement materialized view?when to use materialized view?

1 Answers   TCS,


What are the different options used to configure the sequential batches?

2 Answers   Wipro,


What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,


what is the diff b/w union and joiner and lookup?

4 Answers  


what r the values tht r passed between informatics server and stored procedure?

1 Answers  


Categories