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
- 9662 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 |
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
What are the types of groups in Router transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
how can u load the data in time dimension?
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
How to load query faster,so that It will take less time to load?
What is the benefit of session partitioning?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is blocking transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
In ur current projectu have done any performance tuning of mappings?
Teradata 
