DSXchange

hi, The job details as follows: Source is a sequentail stage , thus extracting flat file and then loading into the transformer to add some rows into the input data . The issue: Import validation failed error Error details: sq_CurrentShipList: Import validation failed sq_CurrentShipList: At field &qu...

Couldn't you just write a parallel job with a server job shared container that reads a server hash file and writes it to parallel lookup filesets? A transformer is probably not required though you might get some metadata related warning messages when you run the job. I would put a copy stage betwee...

In a parallel job, in a sequential file stage if you go to Output>>Properties and then drill down the Options folder you can see it in there. It's usually reads as "First Line is Column Names = False" and you would need that to set to true . If you are having problems finding it in the se...

I was contacted via Private Message regarding this: Hi! Please explain me the process of conversion from server to parallel step by step ( from hash to lookup file set) What I conclued from all post related to this topic: Step 1 : Convert hash file to sequential file Stages:: Hash Stage -------> Se...

Please read this post Your steps are OK. Step 1 must, of course, be a server job and step 2 must be a parallel job. The Hashed File must have a key (one or more columns); the Lookup File Set must have a key (one or more columns). What is it about your design that "doesn't work"? Are rows ...

Hope OP reply to this issue. Can you explain what is not working? Hi , The problem is in the last stage , converting from sq file to lookup file set . The sq stage doen't have any option as (First Line is the Column Name) in the properties( I did search in all Sub properties). I think this the only...

Hi, You need to design a second job. Thanks for a promt reply ! As per your suggestion , the rejects to be send to sq file and create a new job with sq file as Input to the TX and the output of TX to Oracle DB. So, to run the Job I have to design a Job Sequence. Or Is there any other way I can hand...

Hi, The Job desc .........................Lookup file set ...............................|| (input)Funnel ----> Lookup stage -----> TX------> SQ file (out put) ................................|| .........................Reject (lookup failure) .................................|| .......................

Getting it is the easy part. Read the help for the DSGetLinkInfo() function. What do you want to do with it once you have it? First of all thanks for the reply ! I 'll explain you my problem. In the server job, there was a column know as RowCount ( whose derivation was DSLinkRowCount in TX) .Now, s...

Hi! Please explain me the process of conversion from server to parallel step by step ( from hash to lookup file set) What I conclued from all post related to this topic: Step 1 : Convert hash file to sequential file Stages:: Hash Stage -------> Seq Stage ( Server env) No transformer required ? Step ...

Please help me to understand the given error code, I am not able to resolve the issue. Output from transformer compilation follows: ##I TFCN 000001 11:46:15(000) <main_program> DataStage XE Parallel Extender V7.0.0 Copyright (C) 2003, 1997 - 2002 Ascential Software, Inc. All Rights Reserved ##I TOSH...

Probably set the "First line is column names" property to True. Second possibility is to set the field delimiter property to the correct value. Hi, I am getting following error while converting sequential file to Lookup File set seq stage -------------> Lookup File set (1-1 Mapping) Strai...

You can also - more easily in my opinion - create a server routine and invoke it from a Routine activity in the parent job sequence once the job has completed. As, I am very new to datastage, I would appreciate , if you could give me the example of how to create the routine for getting the number o...

Hi !

I am using Parallel Extender, but when I go to the definations to look for DSLinkRowCount in DS Macro, I can't see this macro. It is showing limited macros only but if i check in server jobs DSLinkRowCount is available there. How do I access DSLinkROwCount in Parallel ?

Job Desc

SQ Stage ------------> Lookop Fileset

Error :

sq_RCMAST,0: Field "RC" delimiter not seen, at offset: 5

Note ::RC a Column name

How to rectify this error ?