Monday, 28 March 2016

Getting error SMTPSendFailedException: 530 authentication required when i am trying to send odi logs to mail in odi 11g??

In this post, it discussed about how to send daily status of odi log error / success status to mail.. Everyday wants to get mail from odi , we have to schedule the jobs.
To refer this, following link help for you

https://community.oracle.com/thread/3877296


How to use global variable in target table in odi 11g ?

In this post, it discussed about how to find filenames. Iam trying load multiple files into single interface. 92 files data loaded to single interface.for this i have used varaibles , packages.. My requirement is ,92 files data loaded to target table. Iwant to know which data is coming from which file..To find this, I find this, i have used global variable..
To see, remaining content please follow the below link

How to load all error logs into one single file in odi 11g?


In this post, it discussed about 'If i get errors, after execution of any interface/ package/ procedure in odi 11g,how to load operator navigator logs into single file. To resolve this
 please follow the below link
This link help for you.

While loading lacks of data into target table, odi performance is degrading?

In this post, i have discussed on 
" load data from source(Oracle DB1) to target table(Oracle DB2) in same server
Source table have 45lacks of data. this data have to be load into target table.
I have create interface. i have taken LKM SQL to SQL & IKM SQL to SQL  incremental append knowledge modules i used.. after 24 hours, i have checked status in operator navigator. "its showing status like  loading"
still , interface is in loading status.some times odi is not responded. For this I used different knowledge modules.. "
To see solution for this, Go through this link.

Table rows count is not updated in rpd obiee 11.1.1.9?

In this post, it discussed about Table rows count is not updated in rpd administration in obiee 11.1.1.9.
To resolve this, following link help for you

https://community.oracle.com/thread/3826550

Unable to view the data of Journalized Table in cdc-consistent and cdc simple in odi 11g?

In this post, i have discussed  about "Source table have 1000 rows data.. this data loaded into target table. now target table have1000 rows data. Every six months,
If add 2000 rows to existing source table.. Then newly added or changed data  only  loaded into target table in odi 11g.. then 2000 rows have to load to target table
(now source table have 3000 rows).. recent data only added to target table..
To resolve this, use the following links . It may help for you

https://community.oracle.com/thread/3782432
https://community.oracle.com/thread/3782453
https://community.oracle.com/thread/3784877

Pivot rows converted into columns in odi 11g?

In this post, i have changed rows to columns in odi 11g.
To see, remaining content please follow the below link.

 https://community.oracle.com/thread/3785613

Unable to get the updated rows in scd type3 in odi 11g ?

Flag value is not changing after update the column in SCD TYPE1 odi 11g

How to supress the rows of calculated item & add custom rows into middle of the rows in obiee11g analytics

Odiconsole error Unable to connect to the specified repository. Please select a different alias and try again.

End-to-End Databricks S3 Workflow: Connect, Create Tables, Archive, and Move Files

End-to-End Databricks S3 Workflow: Connect, Create Tables, Archive, and Move Files Introduction An end-to-end Databricks S3 pipeline ofte...