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.
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 |
Scheduling properties,whats the default (sequential)
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
I have 1200 records how can u send it in aggregator with good performance issues?
What is a passive transformation?
what is worklet and what use of worklet and in which situation we can use it?
How to delete the (flat file) data in the target table after loaded.
What is the benefit of partitioning a session?
Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
What is a taget load order?
Explain sessions?
How many joins in Informatica