DSXchange

Hi,

Thank you Eric,

I'm checking all the functions in server and parallel. And Cross checking the functions from other coding languages so that I can found something not there in DS. And checking ur suggestion. am I approaching right way?.

Thank you..............

Thank you Qt_Ky


My POC is like that.. Want to write some creative function

Any idea.........

Yes, For Parallel routines we need to write in C++ code , there is no way to escape.

Hi, Good morning I have to do transactions on the 3 columns op_id , P_id and cus_opp_id. Aggregation functions i need to perform and i have to split the cus_opp_id based on the characters and processing only one part from the split. So, how to do this . All columns are performing from the schema file.

Hi , I have one job which is using schema file. And We have requirement to perform some transactions on the columns which were mentioned in schema file. This has to be done before loading into a target. Target also using the same schema file. Job designed : Seq file --> T/f --> Target . In T/F i nee...

Hi jwiles,

Thanks for reply,

I have given with 'cat' in file pattern .. but i'm getting the follow error :

Sequential_File_0,0: Couldn't find any files on host SEW06728 with pattern CAT//\ \ H:/DEV_VIF0_EE/TEMP/TEST./*.

Do i need to enable /check any option

Thank you

[quote="chulett"]Yup. Crap, how did I miss that? It's right there in black and white pixels in the documentation of all places: File Pattern: Specifies a group of files to import. Specify file containing a list of files or a job parameter representing the file. The file could also contain ...

Hi,

Can you please ellobarate on this. I tried to read from a file which contains the list of file names but it's not considering the columns in the listed files.

Hi Everyone :) , I have control job which executes the sequence of jobs. We have 'job control' tab in job properties. Can I declare the sequence of jobs here to execute successfully. Can we have options to control the job here. What's the difference in executing the jobs in jobcontrol instead in the...

Thank you sekhar , it's working.
Can you expand the command :

sed 'N;$!P;$!D;$d'

I read in some forums but unable to understand.

Thanks in Advance.

By using command stage in server job we can get the list of files and dates. In parallel by using External source stage we can get it (as said by kryton). Here I have an output of file names and dates along with the summary : My question is how to eliminate the summary part at the top and the bottom...

Hi Good morning, I tried to merge the rows in a single column, but it is not working. Eg: i have an input "1","satwika" "2", "Ravi" Expected output is "1satwika" "2Ravi" But I have got the output , same as input. In help it's says that It m...

Hi Everyone,

I am trying to use rowmerger in 8.1X , but not able to find out the difference. Please clarrify this to me .(followed the help also) Thank you.

Regards
Satwika