Answer Posted / suraj kedia
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 |
Post New Answer View All Answers
Explain joiner transformation in informatica
What are the types of lookup transformation?
Write the advantages of partitioning a session?
How might one distinguish in the case of mapping is right or not without associating session?
How to update a particular record in target with out running whole workflow?
What is a repository manager?
where to store informatica rejected data? How to extract the informatica rejected data?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is meant by a domain?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How to delete duplicate row using informatica?
Define the various join types of joiner transformation?
What does command task mean?
What are the new features of informatica 9.x at the developer level?