How can yoU improve session performance in aggregator
transformation?
Answer Posted / pg
Chinna,
If u have't check the option sorted in
input in aggregator transformation but u actully sorted
before with sorter transformation in that case your session
will fail. You must check the option sorted in
input in aggregator transformation if you are using sorted
input to the aggregator .
Plz let do me know if you still have doubt.
pramodgup@gmail.com
| Is This Answer Correct ? | 6 Yes | 16 No |
Post New Answer View All Answers
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What are the advantages of using informatica as an etl tool over teradata?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Explain sessions?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Explain the different lookup methods used in informatica?
is it possible to index the data in cache of lkp transformation ?
Why filter transformation is an active one?
Explain the pipeline partition with real time example?
What does refresh system mean, and what are its distinctive choice?
Explain how many types of dimensions are available in informatica?
How many ways are there to create ports?
In informatics server which files are created during the session rums?
COM components can be used in Informatica