DSXchange

Hi

Can a multiple instance job be a file to table load or only a table to table load ?

Thanks

ray.wurlod wrote:You could try using the Connectors set to 11g variant. Oracle versions are usually well-behaved in terms of backwards compatibility. However you won't have access to any 12c functionality that doesn ...

Thanks,Ray!

Hi All, I have created a job with source has a fixedwidth file and I have created two stage variables and assigned those two stage varibales to a single column.loading the target to oracle table. while running the job i am facing the error 'Caught exception from run locally. COuld any one help me on...

Hi All, Job design is -(sequential file to transformer to sequential file) I am getting the below errors while running a job. I am not sure why this errors are coming one after the other consecutively. Failure during execution of operator logic. node_node1: Player 2 terminated unexpectedly. main_pro...

Hi Everyone, I am working on Datastage V.11.3, Is it possible to connect to Oracle 12c to laod a target table.I cannot see oracle 12c in Oracle connector stage properties.I can see only oracle 10g and 11g verisons in it. How can we connect to 12c using Datastage 11.3 Could you please help me on this...

Hi Chulett,

I have a similar issue. But the environmental variable APT_IMPORT_NOWARN_STRING_FIELD_OVERRUNS=1 shown in the link you provided is not available in Datastage 11.3. So I am not able to suppress the warning.Could you please tell me anyother way to cremove this warning.

Thanks
Rakesh

Hi Chulett,

There are no messages related to Unstructured stage in the log.

Thanks
Rakesh

Hi I created a job with two inputs to join stage. writing the output of join stage to Unstrucutred data stage. Job is running successfully but it is not writing any data to excel.I configured the output unstructured stage like I mentioned the output path and created excel file in that path. Can anyo...

Well... not sure what kind of explanation you are looking for. You would set this property to TRUE if you were processing (sorting) EBCDIC data. This so it doesn't use the ASCII collating sequence on it, since they sort differently. Found this checking online, perhaps it might help. Thanks, Chulett...

Hi Chulett/Franklin, Thank you for your replies. I understand from your replies that, In datastage by default sorting is done by ASCII character set. I would like to know what is the meaning of EBCDIC Character set. what is the difference between the ASCII Character set and EBCDIC Character set? Ple...

Hi All,

why do we use this property in sort stage "Sort as EBCDIC"? Can anyone please explain me about this property?

Thanks
Rakesh

Oh Ok. Do you know who is the right person to talk regarding this?

Hi Chulett, Thank you. I found a training video Server to Parallel transition at the below link.The price of this video is $995. The price is high for me to purchase. Can I get any discount from this price. https://www.shop.dsxchange.net/Category-1-Server-to-Parallel-Server-to-Parallel.htm Thanks Ra...

Hi Chulett,

I got it, but the Videos are availabe for only premium members. Either I should have monthly or weekly memberships

Thanks
Rakesh

Hi Paul,

I heard that there are some DVD'S available in the DSXChange forum and which are good and have some in depth understanding of ETL Jobs and complex transformations

Thanks
Rakesh