Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Difference between sorter and aggregator?
- 2 Answers
- 8818 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / giri
Sorter Aggregator
------- -----------
1.Asc and Desc Only Asc order purpose
order purpose
2.Query is not Passible query is passible
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / dkr
Sorter uses the sorter Algorithm, but Aggrigator uses a
physical Algorithm -(called CLUSTERED Algorithm)
| Is This Answer Correct ? | 1 Yes | 3 No |
Tell me about Propagate functions in informatica
Differentiate between a database and data warehouse?
What are the tasks that Loadmanger process will do?
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
What is the difference between stop and abort in informatica
Have you worked with/created Parameter file
What is a taget load order?
checkout and checkin in informatica 8.6
how we can load rejected record's at run time?(not through bad files)
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
Can we override a native sql query within informatica?
Teradata 
