Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 5 Answers
- 9725 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sony_infa
use session partition to improve the performance.
| Is This Answer Correct ? | 1 Yes | 0 No |
if we do the performance optimization we can achieve the task i think (ie we can reduce the time of loading the data into target)
if my answer is wrong please let me know the write answer
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sony_infa
using session partition we can improve the performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / subhransu panda
Using session partition we can reduce the time.
Because at a time the parallel pipeline created in session partition will process the incoming data ,by distributing the data in equal nos among the parallel pipelines.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is meant by lookup transformation? Explain the types of lookup transformation?
SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that
differences between service based and product based?
Why use shortcuts(Instead of making copies).
can u give example for factless fact table
how to load duplicate row in a target
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
What is power play plug in?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
How do you manage the Parameter files while migrating your data from one environment to another environment?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
Teradata 
