adspace
What are the differences between row-by-row select and cached comparison table and sorted input in table comparison transform?
Answer Posted / Rohit Pant
In Tableau, these three options can be used for comparing two tables. Here are their main differences:
1. Row-by-row Select - This option allows you to define a custom SQL query or calculation to compare rows directly. It does not use any caching or pre-sorting of the data.
2. Cached Comparison Table - This approach involves creating a temporary table that stores the comparison results, which can improve performance for large datasets. The temporary table is stored in memory, and its size is limited by your system's available resources.
3. Sorted Input - In this method, both input tables are sorted on the join key before comparing them. This allows Tableau to use efficient join algorithms, but it may require more computational resources for sorting large datasets.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers