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
- 9510 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 |
i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
what is DSS?
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
Kimball and Inmon methodologies?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
what transformations are used for Variable port?
Slowly changing dimensions, types and where will you use them
What is the difference between a router and a filter transformation?
Define joiner transformation?
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?
Under which circumstances, informatica server creates reject files?
Teradata 
