Hi,
I am working on an ODI package. There is a lookup table that contains about 20 rows in the database. The process needs to retrieve all of them within the package before starting the process. The way I am doing right now is to retrieve them one by one and put them into 20 variables. As you see, to do this, I have to make 20 SQL calls. It is not very efficient. Is there a concept of array in ODI like in programming language that you can just make one SQL call and put all 20 rows into an array?
Thanks,
John