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
What is a passive transformation?
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
What is flashback table ? Advance thanks
write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
Can we have a Mapping without a Source Qualifier?
Is LOAD MANAGER AND LOAD BALANCER same in informatica?
What is IQD file?
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
What is the capacity of power cube?
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
generate date / time dimension in informatica
comonly how meny mappings r there in Banking projects?