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
No I'm not in the wrong forum My aim is to do that using AS. I have read through the iCal dictionnary, but haven't found an entry that seems to do the trick, but then I might have missed it, since the GUI menu names and dictionnary entries have surpr [More]
I have a problem with a HttpUrlConnection object throwing an IOException when it gets an HTTP Error Response code. Especially when there is an actual response from the server sent back that has more details in it that are actually helpful. I would li [More]
I just set my bookmark toolbar up with my most often used URL's. However when I click on a bookmarked URL from my toolbar, it opens in a sidebar to the left on my main screen, rather than in a new tab. The sidebar is cumbersome because I have to scro [More]
Hello, I have an odd issue with (IMAP) mail on both the iPhone and iPad. Since moving to a new web host (Fasthosts), email coming in from certain places - currently Flickr, Amazon and Groupon - have no body content; in the list of messages, the sende [More]
Hi there,  I've recently been looking for a means to pxe boot the lenovo yoga 13 to enable me to then image it. After reading that pxe booting is possible I went out and bought a StarTech usb to ethernet adaptor (USB21000S2) but have had no luck so f [More]
Hi I'm wondering if someone can point me to any resources that will help me learn how to do the following (I'm using Flash CS5 and Air). - import the contents of a particular local dir into variables or - import the contents of a particular local dir [More]
This is a feature on the the 15 and 17 inch powerbooks, but I haven't seen anything anywhere talking about it for the MacBook. Also seeing as how I don't quite have the funds to spring for my own at the time, could one of you unimaginably lucky folks [More]
I have a WebLogic cluster, includes 3 Managed Server running on 2 separate machines (Each has 16Gb Ram and 8 CPU - Sun Sparc). Each start with parameters Starting WLS with line: /usr/jdk/instances/jdk1.6.0/bin/java -server -Xms1024m -Xmx2048m -XX:Max [More]
Can I move LR and PS to my D:drive where there is plenty of space as apposed to my C:drive? And how?I am not answering about PS, as I don't know. for sure, but I doubt that PS cares what drive your photos are located on. You can move your photos that [More]
I have to re install CS4 and wish to know if I have to uninstall it first, or do install over the present copy. If I have to uninstall it how do I go about doing it. The problem is that CS4 is not showing the Canon printer profiles. Canon support nar [More]