Interested to Buy Any Domain ? << Click Here >> for more details...
we r using aggregator with out using groupby?
- 7 Answers
- 22285 Views
- HSBC, Principal Finance, I also Faced
- E-Mail Answers
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
How can we handle two sessions in informatica?
Reusable transformation and shortcut differences
Explain the types of lookup transformation?
What is decode in informatica?
What are the types of lookup transformation?
What is data transformation manager process?
In warehouses how many schemas are there?
When do you use sql override in a lookup transformation?
Explain load alternative records / rows into multiple targets - informatica
What is event and what are the tasks related to it?
Write the advantages of partitioning a session?
Explain sessions. Explain how batches are used to combine executions?
What are the types of caches in lookup?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Do you find any difficulty while working with flat files as source and target?
