If u select groupby port in aggregator what is output and
dont select groupby option what is output
Answers were Sorted based on User's Feedback
Answer / ash
If we select a group by port then : we get the last row of
each group based on the group by port.
If we didn't select a group by port: we get only one row
that is the last row .
Is This Answer Correct ? | 12 Yes | 1 No |
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
What is the advantage of informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
whether Sequence generater T/r uses Caches? then what type of Cache it is
what is polling?
How to display First letter of Names in Caps?
What is difference macros and prompts?
How to eliminate duplicates from flat file..what is the procedure
explain about unit testing? in real time?
checkout and checkin in informatica 8.6
disable caching in a lookup transformation?
Issue with Update override at Target table in Informatica.