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
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
Explain the different lookup methods used in informatica?
What is a pre-defined event and user-defined event?
what is the process we used in joiner transformation,there is no matching column in sources?
What are the measure objects?
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
what is flat file override?
Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?
How do you promote a non-reusable transformation to reusable transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
how to import multiple flat files in to single target where there is no common column in the flat files