we r using aggregator with out using groupby?
Answer Posted / satya
If we use Aggregator without using group by option we will
get only one row from source. It is a default charater of
Informatica.
e.g If there are 20 rows in the source table and only
using SQ and followed by Aggregator then target table then
the target table will be populated by the last row coming
from teh source table.
| Is This Answer Correct ? | 47 Yes | 3 No |
Post New Answer View All Answers
State the differences between sql override and lookup override?
What is meant by a domain?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is a difference between complete, stop and abort?
can anyone explain me about retail domain project in informatica?
What do you understand by term role-playing dimension?
wf dont have integration severances how you can run?
Can we create multiple integration service on single repository?
How many types of sessions are there in informatica.please explain them?
Define Pmrep command?
What do you mean by channel change?
How would you copy the content of one repository to another repository?
Explain about cumulative Sum or moving sum?