Interested to Buy Any Domain ? << Click Here >> for more details...
if we hav 10 records in a file, can we get first record from
it by using Aggregator with out using Groupby Port in it?If
Yes..let me know the answer plz!!!
- 8 Answers
- 29717 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / jhilam roy
Simple answer: NO, provided, only the Aggregator
transformation is used.
In an Aggregator transformation, if no port is selected as
Group By, then by default, the PowerCenter Sever returns the
very last row of the input record set, definitely not the
first one.
It scans sequentially starting from the first port of the
input set and continues till the last port is hit. If it
fails to find any port designated as Group By, the default
nature is to return the last record of the input record set
to the downstream transformation or target.
Any updation is appreciated.
Jhilam
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the differences between joiner transformation and source qualifier transformation?
Clarify the utilization of aggregator cache record?
Explain the etl program with few examples.
What are the static cache and dynamic cache in informatica?
What is native users?
Define the various join types of joiner transformation?
What is the commit type if you have a transaction control transformation in the mapping?
What is the fact table?
How do you change a non-reusable transformation to reusable transformation?
Why do you use Mapping Parameter and mapping variable?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
