oracle table name in oracle stage

[dnat]

Hi,
i am new to server jobs. i am not seeing any tab where i can mention the table name in oracle OCI stage. what am i missing here?

[sachin1]

if your extracting data from oracle check in output tab ---->sql clauses where you can mention table name.

if your inserting records in oci stage then input tab you will see Table name field where you can mention table name requried.

[dnat]

hi, i could give the SQL statement in the SQL tab but it it not accepting the table name from that statement.

it is giving me the following error while i try view data:-

testvalidity..Oracle_OCI_61: Table Name is a required link property for Link DSLink1
testvalidity..Oracle_OCI_61.DSLink1: DSP.Open GCI $DSP.Open error -100.

[sachin1]

you are extracting data from database and in oci stage you need to give table name in output tab ---> sql clauses in oci stage.

error is related to missing table name in your sql clause

[dnat]

thanks a lot..i was able to do it..