Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ETL Lookup problem

JV123Jun 6 2011 — edited Jun 7 2011
Hi,

I have a question about LOOKUP condition in Informatica. below query(TESTING FOR ONE MASTER OU ID) fetching multiple row_wid's for single master ou id. does it really load all those row_wids to the target? looks like it's not loading any row wids to the target if the lookup condition fetching more than one row wid.

SELECT B.ROW_WID FROM W_REVN_FS A,W_PARTY_ORG_D B
WHERE A.MASTER_OU_ID=B.MASTER_OU_ID
AND A.MASTER_OU_ID='1-AOP-1937'

Do I need to make sure lookup fetch only single row per one master ou id?

Appreciate for your help.

Thanks
Jay.
This post has been answered by Navin Kumar Bolla on Jun 7 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2011
Added on Jun 6 2011
#business-intelligence-applications, #problem
3 comments
128 views