DSXchange

Reset the job in Director. Find the event "From previous run...". Tell us what's in that event. ... Below is the message From previous run DataStage Job 2414 Phantom 13801 Abnormal termination of DataStage. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program...

Hi My sources are two flat files, Im using Merge stage to join the two files and write them to Oracle This is the message which log file is showing From previous run DataStage Job 2414 Phantom 6101 Abnormal termination of DataStage. Fault type is 11. Layer type is BASIC run machine. Fault occurred i...

Hi Friends,


I have a column in my target Oracle , which is to be populated with sequnce numbers dynamiccally.


Is there any transformation in DataStage server Jobs as sequence generator Transformation in informatica..


Anyone please suggest me on this.


Thanks & regards
Karthik

Arnd is apparently thinking of the parallel Merge stage which works differently. The server Merge stage directly reads two sequential files and effects a join between them. As you say, it has no Vie ... Yes Wurlod, I am using server job can you please help with this error. From previous run DataSta...

No, can you "View Data" in your 2 source sequential stages in the designer program. ... I am not using any sequential files , Im using Merge and oracle target in my mapping. Im just giving the path of sequential files in merger stage. The flat files are really having data in unix. And mor...

ArndW wrote:Can you "view data" on your 2 input files? ...

View data option is disabled in merge stage.

Thanks & Regards
karthik

You misunderstood. After the job aborts, reset it and then tell us the contents of the 'From previous run...' log message that should show up. ... This is the message which log file is showing From previous run DataStage Job 2414 Phantom 6101 Abnormal termination of DataStage. Fault type is 11. Lay...

ray.wurlod wrote:This is one of those occasions when resetting (not re-compiling) the job ought to yield a "from previous run" entry in the log explaining where the abort occurred. So reset your job and see what appe ...

Nope still getting the same error even after resetting.

Thanks

Hi Friends, My sources are two flat files, I am using a merge so as to compare the 18 matching column values in two flatfiles and if they(18 matching column values are equal)I want to populate the target with some rows other than these 18 into target which is oracle. but when I am using a merge I am...

Hi Friends,

Can anyone lemme know if VARCHAR data type support special characters like '?' or inverted '?'.

If no is there any other data type which support these special characters in server jobs.


Thanks N regards
Karthik

ShaneMuir wrote:

karry450 wrote: No that wont give me my requiremnt.

anyother way please.

Can I ask why that won't give you your requirement. I would think that some sort of inner join in SQL would be quicker?

Are all 19 fields key fields in each table?

They are not the key fields and I want to use data stage here.

ShaneMuir wrote:Can you do a user defined SQL and do the join in your query to give the required output?

No that wont give me my requiremnt.

anyother way please.

Hi friends, I need a some suggestions from the Kingkongs of DataStage please. My Sources: two tables (oracle) target: 1 table(oracle) My source is having 19 matching columns in both tables(sources) and want to populate data to target if the values of 19 matching columns are equal. I have tried oracl...

Hi There, I am new to data stage, I want some solution regarding performance in two cases. 1st Case: My source is oracle and target is oracle. Source could be of 4 million rows can anyone please let me know which way is best I dont have any transformations in between writing oracle to flatfile and t...

Define "performance" in an ETL context. Try writing to a text file, and using a customized sqlldr control file to load into Oracle from that. For example, get the buffer sizes right (rather than d ... Thanks , I have tried selecting Inprocess and defining some buffer 128 and tried this wa...