Sagent Query...

[dipesh73]

Hi,
I have a question in sagent. I have used informatica before the sagent.

Well, I want select a record (few fields) from a look up table. We have a Key look up in Sagent but it returns a single field. is there other transform I can use ?

I tried the SQL command Transform but not able to receive values from look up table ...


Dipesh
(dipesh_rana@ hotmail.com)

 

[DebbieKat]

If you need multiple records back, I would recommend creating a second SQL query transform that selects the columns you would have selected from your key lookup and doing a join between the two queries (make sure you select merge key columns if you don't want multiple columns with keys). This should resolve the issue you are having.

 

[Orbilia]

If you're using a sufficiently recent version of Sagent, then thew Query Iterator transform does what you're looking for.

 

[haucenter]

you can use "Query iterator" transform!