Look up in TPT

Tools

Look up in TPT

Hi All,

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!

Tags (3)
1 REPLY
Enthusiast

Re: Look up in TPT

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.

Br,

Khurram

Khurram