How can yoU improve session performance in aggregator
transformation?
Answer Posted / chinna
what u guys said is so far ok
but what happen if u have't check the option sorted in
input in aggregator transformation but u actully sorted
before with sorter transformation so what will happen in
agg by performance wise?
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Write the different tools in the workflow manager?
What is workflow monitor?
What are Dimensional table?
How big was your fact table
what is size of u r database?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What does update strategy mean, and what are the different option of it?
Explain the mapping variable usage example in informatica
How do you load first and last records into target table?
What are pre and post-session shell commands?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How many dimensions are there in informatica?
how to create user defined function (udf) in informatica
What is domain in terms of informatica?
What is aggregator transformation in informatica?