Sitemap

Amicuk Programming Answers

Index > ikm sql to fileappend >

ikm sql to fileappend

Advertisement

Odi 11g - IKM SQL to Hyperion Essbase (DATA) log file always empty

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

In odi 11g when using *"IKM SQL to Hyperion Essbase (DATA)"* setting the the "LOG_ENABLED" = true, only an empty file are generated. Just "LOG_ERRORS" file (if errors occurs) are created. Is this just an my issue? Can someone[More]

Error in IKM SQL to JMS XML Append

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

Hi I am doing transformation from Oracle table to XML and send that XML to JMS Queue. So i am uing 1) IKM SQL to JMS XML append 2) LKM SQL to SQL In IKM SQL to JMS XML append set following parameters: SYNCHRO_XML_TO_JMS =      true INITIALIZE_XML_SCH[More]

ODI 11.1.1.5 IKM SQL to Hyperion Essbase (DATA) ERROR

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

Hello! I'm loading data from Oracle database table "nbkr_source" to Essbase database nbkr.bdr using IKM SQL to Hyperion Essbase (DATA). I'm using the interface which successfully loading data into Essbase in ODI 10.1.3.5, but this interface does[More]

Error in IKM SQL to JMS XML Append SQLException: Parameter not set

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

Hi I am getting following error please can any one help its oracle to JMS XML integration ODI-1228: Task jms_vendor_xml (Integration) fails on the target JMS_QUEUE_XML connection jms_xml_vendor. Caused By: java.sql.SQLException: java.sql.SQLException[More]

ODI - IKM SQL to File Append - Header not Generated

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

I'm using ODI IKM SQL to File Append to create a text file, but the header is not being generated. And the GENERATE_HEADER is set to Yes. The file is Tab delimited and the Heading (number of lines) is set to 1. Seems to only be an issue with HFM file[More]

ODI IKM SQL to Planning Issue

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

Can anyone help me out with this one? I'm trying to run an IKM to Planning to update a Planning dimension metadata outline and am using the IKM SQL to Planning. After executing it, the Operator shows the status completed but an exception occured from[More]

ODI Error:   Error when selecting IKM Selector: IKM SQL to Hyperion Planni

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

Hi, I'm trying to build the Accounts dimension from a tab delimited text file. I have setup the logical and physical architecture and contexts. On the 'Flow' tab of my Model, I click on my Target header. Then on the 'IKM Selector' dropdown, I select[More]

ODI - IKM SQL to Hyperion Essbase (DATA)

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

Hi, I am using IKM SQL to Hyperion Essbase (DATA), for loading the data to Essbase. Can any one tell me the highest value which i can give for Commit_Interval, in the options of IKM SQL to Hyperion Essbase (DATA)? Thanks V D ReddyThere is not a set l[More]

Change need in IKM SQL/Oracle incremental Update

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

according to my requirement: IKM need to change as * DELETE existing records(NOt all some ) instead of update existing records * insert all records(simply dump) option change as: update and Insert -----> as------>DELETE & insert can anyone provi[More]

Slow Inserts Using IKM SQL to SQL Append

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

Hi all. I'm in a big, big trouble. I have a interface that gets that from the source and insert in the target (obvious)... but the unique way to insert into target is using SQL to SQL Append. Unfortunately, the inserts are about 10 rows/sec. Very, ve[More]

Unable to load data to Essbase (IKM SQL to Hyperion Essbase (DATA)

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

I'm trying to load data to Hyperion Essbase. Unfortunately it isn't going so well. I've followed the instructions but I keep getting this "BUFFER_SIZE" error. I haven't changed the default BUFFER_SIZE (it is set at <Default>:80) and I have[More]

Custom IKM Knowledge Modules are not working with Group By Clause

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

Hi All,    I am facing an issue with custom IKM knowledge modules. Those are IKM Sql Incremental Update and IKM Sql Control Append. My Scenario is 1. Created an interface with table on source and temporary datastore with some columns in target. 2. In[More]

IKM File to Oracle (SQLLDR)

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

Gurus, I am in the process of creating IKM File to Oracle (SQLLDR) per metalink note 762723.1 using ODI version 10.3.5.4, but it doesn't work the way it is described in the note. Thus the questions are: 1. Does the IKM exist and where can I download[More]

SQL to SQL Append

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

Hi, I have a interface to load data from tables to table into same Oracle server, the target table is truncate every time that run interface and the data is just insert (don't update), i read that can use "IKM SQL to SQL Append" to avoid extra l[More]

How to use an ODI variable in an IKM?

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

Hi, I am trying use the value of ODI variable in IKM SQL Incremental Update. The variable contains the count of error records. My problem is how to use the variable in the IKM. I am trying to use the variable in an If condition like: <%if(%>#COuntRe[More]

Problem Loading Microsoft Sql Serer table data to flat file

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

Hi Experts, i am trying to load data from SQL Server table to flat file but its errror out. I have selected Staging area different form Targert ( I am using SQL Server as my staging area) knowlegde modue used: IKM SQL to file Append I reciee the foll[More]

SQL Error : missing expression - Creating XML file with ODI

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

Hi, I saw threads about errors like this and read that maybe it can come from how I chose the staging area. I still can't see where the problem is. I'm trying to create an xml file from data stored in a Oracle database. The interface which execution[More]

Unable to select IKM in project.

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

Hi , This is more of a newbie question. I was trying to go through Oracle's Tutorial Exporting RDMS table to Flat file. For this I created a project and imported a IKM SQL to File Append successfully. I created the Source and Target datasources as we[More]

NOT COMMITING IN SQL SERVER TARGET

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

Hi Guys, Iam trying to load data from oracle to sql server (very less volume around 5k) using IKM SQL TO SQL CONTROL APPEND km in 11g odi and i have selected commit option as well. It runs successfully but i can not see data in sql server target. Wha[More]

Loading from MS SQl Server to Oracle

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

Hello, I am trying to load data from MS SQL Server to Oracle using LKM SQL to ORACLE, this works well with the tables with less number of rows but I have some tables with rows over few Mils so I am trying to use BCP to export into a flat file and the[More]

Hot
Hi All, We have a scenario that we are not getting the total value for numeric fields in ALV report. Below i have given the code used for it. G_KEY = 'X'.   G_NOKEY = SPACE.   G_SUM = 'X'.   G_NOSUM = SPACE.   PERFORM BUILD_FIELDCAT USING 'VBELN'  G_ [More]
My son (4) has his own ipad, but I've always used my Apple ID to purchase apps for him. I'm trying to set up family sharing. Recently I read on Apple's website: Kids under 13 can have an account too. Now kids under 13 can have their own Apple IDs. As [More]
I have a HP photosmart B110 and Macbook Air I need to print double sided but there doesn't seem to be any options on the system preferences to change to double sided, I was able to print double sided with my old laptop which was Dell and allowed me t [More]
I'm getting a message saying I need a new version of Pages to open the document. How can this be? When I click through for more info APple offer me an upgrade at a price of £19.99 and I've read that the 5.2 version of Pages is really glitchy. So, I d [More]
I have an iBook G4 and it's running ssuuppeerr slow but I can't get disk utility to come up after I press C down. I don't know if I'm pressing it at the wrong time but I restart with the C pressed and it gets to the apple screen and it won't go anywh [More]
I'm just learning how to use Dreamweaver 8 and tables. I am trying to use a table with merged cells filled with graphics -- only one graphic per cell. I make my jpg the size of my cell, which it seems to fill. Then, when I upload it to view in browse [More]
Hi, Im using CS3... I want to export from CS3 to mpeg2-dvd preset ( ntsc high quality, which is set to 4 out of 5 on the quality slider setting ) My footage is 720x480i 29.97, 16:9 The dvd will be watched on computer and Digital TV ... so I'm thinkin [More]
Hello, I cannot download an application from Apple store. A message appeares  "your request cannot be processed. Error code 1009 "hi i have a messege ( your request cannot be processed error code 1009) my iphone is 4s with ios 7.0.4 . so cannot [More]
Hi, I am not able to transfer photos of my I phone(My Photostream) to my computer... Can anyone help.....  Also the icloud app from my desktop is not syncing up the photos with phone. Even not able to take backup. Can anyone help how to do it. Thanks [More]
Hello. I'm playing around with GIMP and Idesk. I'm making icons and would like to know the actual exit command for openbox to put in an Idesktop lnk-file so I only have to click on an icon to exit openbox. Last edited by jai134 (2009-04-08 19:14:53)i [More]