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, The following are the softwares which we have installed. 1. Adobe Reader - 7.07 2. Adobe Acrobat Professional - 7.0 3. Adobe LiveCycle Designer 7.1 4. Adobe LiveCycle Forms 7.2.2 5. Adobe LiveCycle Form Manager 7.2.2 6. Adobe LiveCycle Workflow - [More]
This is a followup to How do I prevent the patch from advancing multiple times per switch press? The Mainstage 2.2 release notes list blocking unwanted incoming controller messages as a feature. However, I can't find anything in the docs about it and [More]
Updated to 5.0.1 on Saturday - that was bad. The backup kept failing and instead restored phone from an old backup. Lost photos, contacts and important messages!! Not impressed. Anyway biggest issue is since then my battery has suddenly shown very po [More]
it works fine using a live cd, but not in arch im using a custom kernel and i dont think anything was missed in terms of support i can only test this on one box since it has my dvd rom and dvd burner on it the disc is fine and can be read ok by more [More]
This message has me going crazy, and not for the first time. I notice that OC4J reconfiguration/restart and application deployment now-and-again results in OC4J not coming up. When I try to start it using OEM; it ends with Already Up, but it isn't. U [More]
When I try to set-up iCloud, I get error message "Verification Failed - The certificate for this server is invalid. You may be connecting to a server that is pretending to be "setup.icloud.com" which could put your confidential information [More]
hi folks i've got a text string  text = 'Steve L Tyler'. I want first name and last name from this string. How to write this command. i mean I want first name : Steve last name Tyler It could be 'John F K Anderson'. and then  I would need first name [More]
I inadvertently deleted all the mail in my in box and emptied trash. Can they be retrieved?Data Recovery – Best Data Recovery – Disk Drill Data Recovery – Data Rescue Data Recovery – File Salvage Data Recovery – Stellar Phoenix Data Recovery - uFlyso [More]
I have a folder with 2000 files. I need to sort these files into two folders. I have sequentially renamed the files in automator so that a number is the first character of each file. I need to put the odd numbered files in folder one and the even num [More]
Hi I just wondered if there is a way to ensure that when you've added/ removed and moved panels around Elements 10 Editor panel bin etc that they will stay there when you next open the program after a computer shutdown? I see in the adobe help with w [More]