In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
Answer Posted / ramu
The column which is used as a key prot in sorter should be
the group by port and check box sorted input in aggregator
t/r properties
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
What is the use of transformation?
What are the tasks that can be performed using sq?
Explain lookup transformation source types in informatica
What is deployment group?
How to create or import flat file definition in to the warehouse designer?
How can we handle two sessions in informatica?
What are the different options available for update strategy?
What is the scenario which compels informatica server to reject files?
Describe an informatica powercenter?
What are the different components of powercenter?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is a stored procedure transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?