what is mapping performence?
Answers were Sorted based on User's Feedback
Answer / vino
Mapping performance is nothing but u tune the mapping to
achieve better performnace .
Like to use filter after sq,using sorter before
aggregator,deleting unwanted fields in the lookup etc.....
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / nafeeja
Mapping Performance is to tune the mapping for better performance. To achieve this first we need to find out the performance bottle necks at three levels and optmise those.
1) Identifying Source Bottlenecks
2) Target bottleneck.
3) Identifying Mapping Bottlenecks
| Is This Answer Correct ? | 0 Yes | 0 No |
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How many numbers of sessions can one group in batches?
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
Explain incremental aggregation in informatica
If informatica has its scheduler why using third party scheduler?
How i can upload the MainFrame source For Informatica ?
I want skip first 5 rows to load in to target? what will be the logic at session level ??
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
Enlist the various types of transformations.
What is an aggregator transformation?
how can we load starting with 11th record of a table from source to target
how to load rows into fact table in data warehouse