What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
- 1 Answers
- 998 Views
- I also Faced
- E-Mail Answers
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 |
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
To import the flat file definition into the designer where should the flat file be placed?
source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?
without update strategy how to insert &update?
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
Mention a few design and development best practices for informatica?
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
can we use cartesian join in informatica
How to jion 2 tables, without using any condition?
Mention few advantages of router transformation over filter transformation.
why sequence generator should not directly connected to joiner transformation ?
Teradata 
