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!

Variable not in select list issue

SaroJan 8 2013 — edited Jan 9 2013

Hi friends,

To the existing OBIA mapping, that is for one of the SDE mapping i dragged a single column from source to source qualifier and also updated that column in the sql query of the source qualifier and finally dragged it to my target staging table.

After that if i tried to run that SDE task in my DAC means, it is failing and returning the below error in log

ora-01007 variable not in select list in informatica

since i have checked and verified the order of the column in the source qualifier port and the query. It is same, but then too returning the above error.

What is the fix for it.

Thanks in advance.

Regards,
Saro

This post has been answered by Saro on Jan 9 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 6 2013

Added on Jan 8 2013

#business-intelligence-applications

7 comments

3,753 views