In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
Answer Posted / vasu
Did you select any column for Group by port ?
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the session task and command task?
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
Why do we need informatica?
Explain the different lookup methods used in informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
According to his methodology what all you need before you build a datawarehouse
What are connected or unconnected transformations?
Can we create multiple integration service on single repository?
Why update strategy and union transformations are active? Explain with examples.
What is the need of an ETL tool?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
State the limitations where we cannot use joiner in the mapping pipeline?
Explain what transformation and how many are there in informatica?
What is lookup transformation?