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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Using ODI variable

user12251389Oct 6 2021 — edited Oct 7 2021

I am using ODI 12c. I have created Variable and i am trying to use this variable value in filter condition to filter the data based on a timestamp. But its not working.
Basically what i am trying is from my target table TEST_SDADDR i am trying to get max Timestamp everytime and trying to pass this value in Filter condition so that from source table CSL_STG_DEC_SDADDR, i will always load the latest data into my target table TEST_SDADDR.
This is how i have created variable and trying to use Variable in filter:
Step1.

Step2.

Step3.
I am getting below error:
ODI-1593: The following bind parameters (36:29.0) in the task command are not bound to any value. All the bind parameters should be bound for the command to be successful.

This post has been answered by Rodrigo Radtke Souza on Oct 6 2021

Jump to Answer

Venkat Krishna

Hi,

You can install rcu on linux.....

You can follow the below link.

http://obieedeveloper.blogspot.com/2012/10/how-to-install-obiee-111116-on-linux.html

Thanks
Venkat
http://obieedeveloper.blogspot.com/

Edited by: Venkat Krishna on May 16, 2013 11:46 AM

1 person found this helpful

Ysaki

Hi Venkat and thanks for the reply

which is more reliable and more preferable ? to have the DB, RCU and OBIEE all on linux or to have the RCU and OBIEE on windows ?

Also when should i install the JDK and Weblogic ?

Thanks

Venkat Krishna

Hi,

R u installating it on server (or) laptop ? it depends......

When you say reliable what do you mean? what is your environment...

Thanks
Venkat

1 person found this helpful

Ysaki

thanks for replying

its going to be on server, what i mean in reliable is linux have less issues and more performance than the windows.

my environment is my OS in linux 64 bit and has couple of database R11

thanks

Yogi1729

Hi ,
install all the RCU and OBIEE on the same Linux machine it will good. and you can accesses this in windows machine as u state that Linux is server.

Thanks,
Yogi.

Edited by: Yogi1729 on May 17, 2013 8:35 AM

1 person found this helpful

Ysaki

Dear Yogi

Thanks for your help and and reply

Thanks

1 - 6

Added on Oct 6 2021

#business-intelligence-applications, #data-integrator, #filter, #odi, #oracle, #system-management-and-integration, #variable

16 comments

2,200 views

1 mention

Analytics Software

Using ODI variable

Comments

Post Details