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

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in

2 Answers  


Did u used latest transformations of 8.6.0? for what?

0 Answers  


sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers  


How can we update a record in the target table without using update strategy?

0 Answers  


Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers   IBM,


wht is full process of Information source to target just like stg to productuon and development

1 Answers   Informatica,


In joiner, how to load Master table in Target?

2 Answers  


what is runtime variable?

3 Answers   TCS,


i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,


What is the use of transformation?

0 Answers  


Write the program through which the records can be updated?

0 Answers  


What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,


Categories