Sitemap

Amicuk Programming Answers

Oracle data integrator , reverse the tables

-0001-11-30   Views:0

Advertisement

Hi all, am new to odi. Is there any possibility of passing the table name as parameter to reverse it.. am facing issues in reversing the table ,as there large number of views and tables in a schema it takes long time to import. even i tried using sel

Hi all,
am new to odi. Is there any possibility of passing the table name as parameter to reverse it.. am facing issues in reversing the table ,as there large number of views and tables in a schema it takes long time to import. even i tried using selective reverse also.
kindly let me know.
Thanks in advance,
nithya

The replay answer
Advertisement
Hi All,
I need to compare two tables say A which is in source and A1 which is in target based on id, if id exists in A1, then need to load the contents from table c in source to table c1 in target. if not need to throw a error message. this is the scenario.
Please let me know how to do in ODI. Am completely new to odi. problem is i dont know how to compare the id's , before using IKM incremental update knowledge module.
Thanks in advance

Go to See the other 7 answers

Oracle data integrator , reverse the tables

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, am new to odi. Is there any possibility of passing the table name as parameter to reverse it.. am facing issues in reversing the table ,as there large number of views and tables in a schema it takes long time to import. even i tried using sel[More]

Oracle Data Integrator 11.1.1.5 Work Schema - List of Privileges

Category:DefaultRelease time:2015-10-11Views:130

Hi All, Oracle Data Integrator 11.1.1.5. Extracting data from Oracle DB for Oracle EBS 12.1.3. Customer created read-only schema (XXAPPS) to extract the data from EBS. For ODI Work schema we now created one schema 'XBOL_ODI_TEMP' on the source DB. We[More]

"Oracle Data Integrator" with "Total Recall"

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, We are planning to use Oracle Data Integrator 11g for performing ELT in Oracle 11g database. We are also planning to enable the "total recall" (flashback) technology and house all our tables on it. Question I have in my mind right now is[More]

Oracle Data Integrator - Real Time Integration

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I want to know that, is there any possibility of integrating data in real-time using Oracle Data Integrator? If yes, does it affect the OLTP system performance? (Could it read from db logs,etc..) Thanks..Using ODI with Logminer-based CDC will aff[More]

Unable to download Oracle Data Integrator-Version 11.1.1.6(Important)

Category:DefaultRelease time:2015-10-11Views:130

Unable to download Oracle Data Integrator with version 11.1.1.6.Hope this could be resolved ASAP.966234 wrote: Unable to download Oracle Data Integrator with version 11.1.1.6.Hope this could be resolved ASAP.What is the file you are trying to downloa[More]

Problem in Scheduling a Package/Interface in Oracle data Integrator.

Category:DefaultRelease time:2015-10-11Views:130

Hi all, I have a problem in scheduling in odi. I have followed the steps:- 1) launch a scheduler agent from commnadline using the command agentscheduler "-port=20300" "-v=5" 2.)created a Physical Agent and Logical Agent on this port 3.[More]

I red that Oracle Data Integrator provides more than 100 KMs out-of-the-box

Category:DefaultRelease time:2015-10-11Views:130

I red that Oracle Data Integrator provides more than 100 KMs out-of-the-box. Is anybody have any idea how I can reach or view it or use it ?I got it its under <Oraclehome>oracledi>impexpRead other 2 answers[More]

Generic Java for Oracle Data Integrator 10g (10.1.3.5.0)

Category:DefaultRelease time:2015-10-11Views:130

Hi, How can I install the Oracle Data Integrator Client in my MacBook. So the generic version should be the right one. But there are versions for windows, linux, solaris, HPUX and AIX.. but no generic java version. The version 10.1.3.4.0 has an gener[More]

How to set Oracle Data Integrator Timeout paramter value as unlimited

Category:DefaultRelease time:-0001-11-30Views:130

Hi Can any one help me how to set Oracle Data Integrator Timeout (ODI menu>User Paramter>Oracle Data Integrator Timeout > paramter value as unlimited. By default it is 30 and i want to change it as unlimited. I am connecting linux box through win[More]

How to use a variable on columns using Oracle Data Integrator

Category:DefaultRelease time:-0001-11-30Views:130

How to use a variable in oracle Data Integrator expically on colums.yes exactly,i selected update on new column,if i didn't select update on new colum then error is not coming regarding update. but this time error is coming on "insert new rows".[More]

** Regarding Oracle Data Integrator Companion 11gR1(11.1.1.7.0)

Category:DefaultRelease time:-0001-11-30Views:130

Hi Experts, I would like to Know regarding.. Oracle Data Integrator Companion 11gR1 (11.1.1.7.0) Includes: Oracle Data Integrator Application Adapters for Hadoop, Oracle Applications, SAP ERP and BW (Hadoop is Newly added when compared with the older[More]

Hot
I am currently designing a VI which reads data from a spreadsheet which is being updated from another source. I currently have my VI reading the information and displaying it on waveform charts. I have 13 sample points each of which has a chart of it [More]
Hi I have a number of customers that are thinking of upgrading from 8.5.3 to 9.1. The conventional wisdom is to first move to 9.0, fix the problems with scheduled tasks etc, and then move to 9.1. I heard a rumor that Oracle might release an upgrade p [More]
I want to install Oracle Database and Oracle Grid Infrastructure for a standalone server for ASM and Oracle Restart. I understand that they need to be installed in different folders with different access rights. But how it is better for making? In do [More]
I have finally setup the spam quarantine after a year of use. My problem is I have several resources that get email and a several users that monitor those resources. How do I allow them to see the quarantined email of another account? ThanksIf you ar [More]
Dears I am not very much conversant with Controlling. Still I am supposed to do the period opening activities in Controlling. I need a clarification on the Cost Centre Splitting. Cost Centre 300001 is having 3 activity types : MACH001, LAB001, FIN001 [More]
When i call Adobe Reader ActiveX control in my app,i found my Reader plugin cannot get the right file URL. Example i call m_pdfViewer.LoadFile("C:\\test.pdf"), then the file url i got in my plugin will be C:\\test.pdf + some strange characters. [More]
Hi, I just updated my AME CC application to version 2014.2 and the 'Renderer' option to allow use of the GPU CUDA cores is no longer available. Is related to the udpate? Or does the renderer option "Mercury Playback Engine GPU Acceleration (Open CL)& [More]
When I try to add jpg files to Premiere Elements 9 timeline, I get an error saying "This file is not supported, or the required codec is not installed". Windows 7 can open/display every one of the jpg files.  Photoshop Elements can open them as [More]
Hello all, Working on a project in FCP. The intended delivery format is mini-DV tape. I'm working on a sequence with the following settings: (basically NTSC DV anamorphic) Frame Size: 720x480 NTSC DV (3:2) Pixel Aspect: NTSC... 720x480 Anamorphic 16x [More]
We're having problems connecting to websites with DW CS3. The mac can browse to sites, ftp using Fetch, etc. but cannot connect via DW. We also have a pc running DW CS3 going through the same connection (cable modem) as the mac and it connects with n [More]