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 |
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
What is joiner cache?
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
Why the workflow is failed after running two hours in informatica?
what type of transformation is not supported by mapplets?
What is difference between a gateway node and worker node?
How to update a particular record in target with out running whole workflow?
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,
whatis the default data driven operation in informatica