DSXchange

Hi,

Yes. It becomes normal lookup not the sparse. Sparse Lookup means using reference link between DB stage (it may Oracle OCI or any other stage which is access database directly) and transformer. In this case Hashfile stage is not used.

Hi, Using Convert Function in the transformer double quotes(") can be removed.But unable to remove the double quotes in the sequential stage itself. In sequential stage, used Quote character property with the options of double quotes (") and (000). Tried both the options individually but u...

Hi Major,

Thanks a lot. Link provided by you helped me to know how to extract Logfile from DataStage Director into FlatFile.

Hi, I am using Websphere Information server Edition version 8.1. Let me explain in brief about the job i am trying to execute. In my job source system is flatfile which contains 4 attributes. Following are the source file structure. Column Name Col1 Col2 Col3 Col4 DataTypes Varchar2(10) Varchar2(10)...

Hi Ray, Can you please explain me in brief, how to capture job logs into a flatfile through job. As i dont see any stage that captures logfile in server edition like in Parallel edition. Also i dont find any functions so called COMO & DIVERT.OUT in server edition can you please help me how to us...

Hi, Tried in every possible way to fix the issue but could not. Now my doubt is can we use Oracle OCI stage as dirtect lookup from database in 8x server version. If 'YES' , am i using the right stage. I know that we can implement in 7x server version, as i have used but not sure about 8x version. Ne...

Hi,

Is there any way to extract Job Logfile from Datastage Director into a flatfile directly.


Thanks in Advance.

Hi, Moment this error(ORA-01036: illegal variable name/numbe) occured, first thing i have done is executed SQL query in the toad. Query is absolutely working fine. Query used in Lookup is (SELECT COL1 FROM TAB1). I do accept that there is not saperate Sparse Lookup stage in the Server Edition, but f...

Hi, Facing issues with Sparse Lookup. As i am trying to load data from Flat File to a Oracle Table using Sparse Lookup for validation. Following is the error occured while loading the data . Error number : ORA-01036: illegal variable name/number. Source File structure: col1 col2 col3 aaa bbb 1 bbb c...

Hi Chulett,

Thanks a lot. Issue is resolved :D .

Hi, Source is Flat File and Look up is based on Master Table(Key column col1). Before 1st run, lookup contains no records. Therefore in 1st run all source records has to be loaded in the Master Table (by satisfying Master Table link condition). Again in 2nd run, if the source records exists in the m...

Hi Zenith, As per your suggestion, tried to insert data into Master & Detail table using Oracle OCI stage by checking Enable Transaction Grouping property in Transaction Handling tab. However i am facing issues while loading data into master table. For Example Source Data : col1 Col2 Col2 1 aa b...

For Better performance, use Join Stage which also handles fast sort method.

Thanks & Regards,
Sam

Please explain how to migrate the 7.1 jobs from windows to unix.