What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
Answer / ysindhureddy77@gmail.com
If we do not use an input port in group-by neither in aggregate expression, the Integration Service
will return only the last row value of the column for the input rows.
For example, if we have 100 rows coming from source then aggregator will output only the last record (100th
record)
| Is This Answer Correct ? | 0 Yes | 0 No |
how can one eliminate dupliacte data with out using distinct option?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
What is the difference between Normal load and Bulk load?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
What is the default join that source qualifier provides?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
wf dont have integration severances how you can run?
My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….
without update strategy how to insert &update?
In informatica workflow manager, how many repositories can be created?
What are the advantages of using informatica as an etl tool over teradata?
What are the session parameters?