when we dont use aggregator in mapping ?
Answers were Sorted based on User's Feedback
Aggregator transformation is used to calculate values in a
group. It is the only t/r which can be used for aggregate
calculations e.g: Sum,avg,max,min,count....
So when we don't need any such aggregate calculations, than
we don't use aggregator transformation.
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / vikram
when thre are no group by or any other calculations required
| Is This Answer Correct ? | 9 Yes | 1 No |
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
without dynamic lookup transformation how to insert new rows and update existing rows?
Explain the different dimensions.
what is the difference between repository & Intergration service
How to eliminate 1st and last rows from the source and load the inbetween rows.
Target increases every day even though no new record was inserted
What is an Integration service in Informatica?
How many mapplets u have created? and what is the logic used
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
what is the complex transformation you used in informatica
I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance