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
I bought an iPhone 5 from the Apple store with a new Sprint contract in Sept. 2012.  I would like to know if I port my number to T-mobile and pay off my Early Termination fee with Sprint, will my iPhone 5 will be unlocked to use with T-mobile network [More]
sending photos via email on my iPhone 5 was so easy once upon a time, now it is impossible, any advice?Chris thanks to your prompting, i found another mail icon that when touched requested a password. i now can send photos once again woohoo thanks ag [More]
wrong forum, sorry!!See my reply in the Dreamweaver forum... and please don't post the same question in multiple forums... Michael Hager www.cmhager.comRead other 3 answers [More]
New Mac Pro 12-core running 10.10.2, main monitor is LG UM95 connected via thunderbolt, also a Panasonic TV connected via HDMI to the HDMI port. At every restart, the display settings revert to "mirrored" mode. How do I fix this?Try resetting th [More]
I'm heads down working with the FlashBuilder tool which is heavy AS3, and have used Flash CSx for years. My question: I'm assuming my AS3 skills that I develop with FlashBuilder will be directly applicable to Flash CSx, correct? I understand I'll nee [More]
Hi. I'm trying to implement Incentive & Commission Management from the technical perspective, and i'm looking for documentation and technical guides. Right now I'm a bit lost, ERP source (abap) configuration is almost done by the consultant but I got [More]
I have Apache and Jrun 3.1. When I'm in https and I run request.getScheme(), I get http instead of https. From HttpUtils.getRequestURL(request) I get a string beginning with http:// but containing the correct https port (443). I was using Jrun's BASI [More]
when i put random transitions and convert the photos into a slide show, all of the "flip" transitions black out just prior to the the next photo. how can i fix that. I just purchased and reinstalled the ILife '06 thinking this would fix it, but [More]
Hi Iam trying to create a service call using DI server. I have unlocked the current period (June 09). I am getting the error "Period is locked fr new data" when i run thru the SDK. When it try to create from B1 service call screen, i am able to [More]
Hello, my applet downloads the contents of an URI from the same domain, using a relative URI. This should be AFAIK an unprivileged operation and should be always allowed, even for unsigned applets, such as mine. (In contrast to accessing URIs from a [More]