I know that I can do inner and (unchecked inner) for left outer joins? I have used those successfully. Are any other joins supported? |
Not yet outside of ELT components.
Is there a way to concatenate multiple tables or files together? |
Not yet but see 425 and related 944, work is currently in progress. We should distribute a solution in TOS 2.1.0 (july 2007).
Is tUniqueRow the best way to check for an remove duplicates? |
tUniqueRow doesn't "check", it only "skip" duplicates. In the near future, you'll be able to link an output component to tUniqueRow reject flow. See 1071.