DSXchange

Sorry folks,
I forgot to mention that i have all the required licenses set up properly,i also validated installed products via ISATool.

Hello Friends, I am trying to create a "Information Services" Type project with administrator rights.But i am not able to create it. Here is the error i am getting. Please let me know if you ever faced these and fixed them. Here are my issues 1) I made sure that i have Suite Component Role...

I was able to use "DIRECT=TRUE" explicitly in sqlldr command using external target, by taking the input from dataset using 'data=\"-\"' i.e.stdin

Hi Craig,

I am using Oracle Connector Stage. I put the bulk load option on and no indexes. Please let me know if you faced this.


Thanks & Regards
Koti

Hello, I am trying to bulk load the data, i also overrided the APT_ORACLE_LOAD_OPTIONS with "OPTIONS(DIRECT=TRUE,PARALLEL=TRUE)", however its not working, when i check the explain plan in Oracle(target db), its always going to Conventional Path though i set Direct Path as True. Did anyone ...

Hi Craig/Timato, I did load the problematic fileset into a flat file and successfully loaded into Oracle using Connector via BulkLoad. I dont believe its problem with Oracle Connector.But i think its either problem with fileset or dataset.I am getting error with both Fileset and Dataset. Please let ...

Hello all,

I am getting ORA-39767 while doing a bulk load from a fileset to Oracle DB using connector. I searched online and dsxchange with no luck. Please let me know if you ever faced this and solved it? Thanks a lot for your help in advance.


Thanks & Regards
Koti

Hi Jerome, Are you adding any operators with IsNull Clause ie. IsNull(SourceColumn1) And Len(Trim(SourceColumn1))=0 , If yes then try to split it out like below in Stage Variable. If IsNull(SourceColumn1) Then "Do Something" Else (If Len(Trim(SourceColumn1))=0 Then "Do Something"...

You may simply call unix shell command in sequence `date +%Y%m%d%H%M%S` and pass it as parameter the next job activity

Craig
you rock....Thanks for your help

Hello All, I am trying to copy a dataset using orchadmin copy command.Though the source dataset is of 160GB,(Counted the data file bytes), orchadmin copy command is making a file bigger than target file of 480GB(Again counted the data file bytes) and failing with no space on device-3times the size o...

Hi Craig, Thanks for changing the subject. Hi Ernie, I am trying to use java client stage as source and load dataset. My class file is compiling fine and able to call it successfully without any problem.I am using setFetchSize through get more data for ResultSet interface for tuning purposes in my I...

Hi all, I ran into problem of not able to process all records in one go, I am trying to process a large ResultSet, I am also using setFetchSize parameter for tuning purposes. However I want to know if a single process() call can handle the complete set of input records.As per the docs, its Yes, howe...

Hi,

You dont need to rely on JDBC Connector alone, you can invoke the class with Java Client/Transformer stage in 8.7, as long as you have proper JAR files to connect to Apache Kudu in your classpath while compiling your code.

Thanks & Regards
Koti

'i' is RowNumber value Craig.