What is the Difference between sorter and aggregator?
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 |
In joiner, how to load Master table in Target?
write a query to retrieve the latest records from the table sorted by version(scd)
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
Explain about Informatica server process that how it works relates to mapping variables?
What do you understand by SOA of Informatica?
How do you handle decimal places while importing a flatfile into informatica?
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com
how the informatica server sorts the strings values in rank transformations?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is an MDDB? What is the difference between MDDBs and RDBMSs?