If we are using an aggregator but forget to mention the
group by port .what will be the output??
Answer Posted / srinu
No group by Port-
The AggTrans wil check for group by Column port up to last
column. No group by port was find,The AggTrans wil return
the last row only.
Every Column row wil check for Group by port done or not,
up to last row.
Finally (By default) last row will return.
Last Row still waiting for Group by port.,,,,
Thats why Group by prot is must.
Any Corrections,,,,,srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 57 Yes | 4 No |
Post New Answer View All Answers
What are the new features of informatica 9.x developer?
How to create a non-reusable instance of reusable transformations?
Informatica settings are available in which file?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
what is the size of u r source(like file or table)?
What is different between the data warehouse and data mart?
What are the measure objects?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
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 are the differences between oltp and olap?
Is it possible to define a single node as a Gateway node as well as worker node?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What does “tail –f” command do and what is its use as an Informatica admin.
Explain incremental aggregation in informatica
r u done any partitions in ur project?