Can anyone kindly let me know is it possible to perform look up in TPT ? I am having around 100K record in a file. I want to load it into a table by looking up another table(by joining a column between file and Table). Can someone kindly let me know is it possible. Thanks in advance!
NO. As you will be using two separate operators: FileReader to read the file and export to select data from table.
Why dont you load the file in step-1 into a temp table, and use that table to join in step-2. This will also give you best performance.