Interested to Buy Any Domain ? << Click Here >> for more details...
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
- 1 Answers
- 1611 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How to configure mapping in informatica?
Separate from an archive server and a powerhouse?
What do you understand by term role-playing dimension?
What is aggregator transformation in informatica?
How does a sorter cache works?
What is the difference between STOP and ABORT options in Workflow Monitor?
Is stop and abort are same in informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the guidelines to be followed while using union transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
can you please explain me pre session and post session options?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Can we create two repositories on same database instance in oracle?
