In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal.
Is there any othere transformation than the aggrator? if
yes how?
Answer Posted / eswar
No, In Informatica, you dont have any other transformation
than Aggregator. Aggregator is used for calculatins such as
Avg, Sum which are performed on groups.
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How to update a particular record in target with out running whole workflow?
How can we use mapping variables in informatica? Where do we use them?
What are the uses of etl tools?
What is the use of an aggregator cache file?
How do you load unique records into one target table and duplicate records into a different target table?
Describe the impact of several join conditions and join order in a joiner transformation?
Briefly define a session task?
What are the types of presistent cache in look up tr.
What is the Rank index port in Rank transformation?
Explain the types of transformations?
how to load dimension table and fact table. plz tell me the steps.
Tell me about Propagate functions in informatica
What is target load order?
What is a dimensional model?