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.
Answer Posted / 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 |
Post New Answer View All Answers
How to improve the performance of a session using sorter transformation?
How to do unit testing in informatica?
Is there any way to read the ms excel datas directly into informatica?
What are the uses of etl tools?
What is informatica worklet?
What is meant by incremental aggregation?
What is different between the data warehouse and data mart?
How might one distinguish in the case of mapping is right or not without associating session?
Different sorts of metadata that stores in the storage facility?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Can we get 1st record through Informatica(without sequence number).
Under what condition selecting sorted input in aggregator may fail the session?
How many ways are there to do 'remove duplicate records in informatica'?
Write the unconnected lookup syntax and how to return more than one column.