Answer Posted / bsgsr
mappings can be tuned at diff transformations level.
ex; look up can be optimised by enabling the cache.
aggregator can be optimised by using sorted inout.
filter can be optimised by using it as close as possible
to the sql. so on
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Describe an informatica powercenter?
How to update or delete the rows in a target, which do not have key fields?
How do you migrate data from one environment to another?
Is it possible to create multiple domains on a single Informatica server?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How does a sorter cache works?
Why do you use Mapping Parameter and mapping variable?
How do you change a non-reusable transformation to reusable transformation?
What is sequence generator transformation in informatica?
What is enterprise data warehousing?
What is xml source qualifier transformation in informatica?
Did u used latest transformations of 8.6.0? for what?
Explain joiner transformation in informatica
What does command task mean?