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

how to run the batch using pmcmd command

2 Answers   Wipro,


my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced

9 Answers  


what is size of u r database?

0 Answers  


what is update strategy transformation ?

7 Answers   TCS,


Is it possible to define a single node as a Gateway node as well as worker node?

0 Answers  






why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,


what is diff b/t sorter t/r and agg have the option sorter property...

0 Answers  


In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 Answers  


How we can create indexes after completing the loan process?

0 Answers  


difference between informatica 8.1.1 and 8.6

0 Answers   TCS,


what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,


what is the difference between mapplet & stored procedure?

1 Answers  


Categories