DSXchange

Hi Nair,
Merge KeyCoulmn Name and Type should be same.
Lenth may be differ.

If I'm wrong, Some body Please correct me.

Thanks in Advance
Arvind

Hello Everybody, I need to create a file with summary and detail records. Source file contains only the detail records, ftp stage will read the data from the source, need do sort and group the detail records based on 2 columns. Need to create a summary record for every group. In Target I will have b...

Hello Everybody, I'm trying to read data from the fixed width file, I'm getting the following error: function 'utf_to_row()' failed I defined all the column types as char and null able NO and the correct length. Please suggest me the solution for this. Thanks in Advance Arvind

Hello All,
Thanks to eveybody who replied my question.

I created two output's where in one link i gave column B as null,
Using funnel stage I created the sequential file with desired output.


Thanks and Regards
Arvind

Hello All, I want to know how to load summary record and detail records in a single target file. number columns in summary and detail records will be different A1 abc 20051009 (summary record) B abc 20051009 123 456 678 (detail record) B abc 20051009 234 532 567 (detail record) B abc 20051009 654 23...

Hi All, How can I give a dynamic condition in the filter stage. I need to generate a file based on the source column value. eg Column name is REGION Values of REGION: AAA BBB CCC DDD I need to create a file for each new value of the column REGION. Please suggest me what to write in the where clause....

Hi All, Thanks ucf007, Eg. Source columns A B C D E Source records 123 AAA 2354 4656 bbb 234 BBC 8762 9876 ddd Target columns A B C D E Target Records 123 2354 4656 bbb 123 AAA 2354 4656 bbb 234 8762 9876 ddd 234 BBC 8762 9876 ddd I want the out put in single target file with two records with the ab...

Hi, I want to know how to load 2 records in to the target from single source record. Eg. Source columns A B C D E Source records 123 AAA 2354 4656 bbb 234 BBC 8762 9876 ddd Target columns A B C D E Target Records 123 2354 4656 bbb 123 AAA 2354 4656 bbb 234 8762 9876 ddd 234 BBC 8762 9876 ddd In the ...

Hello Everybody, I have sequential source file which consists of a country column, I need to create job which will create individual file for each country. I know we can use the FileSet stage for this. I want to know how to define partitions for each country. How can we give our own target path and ...

Hi All, I have two source files which will be merged and loaded into the target output file. Need to implement the delta logic on these two files. There are some 50 columns in the source 1 and 30 in source 2. We are using 30 columns from source 1 and 5 columns from source 2 for merging. Which is the...

Hello All, Thanks Arnd and vmcburney I have created the Datastage job with ftpstage transformation stage and FileSet stage. Job is running fine and I am getting data in (/detld2/etl/ascential/scratchdatasets/datasets) this directory. Data in four nodes with different file name: export.p453112.P00000...

Hi All, I'm getting a file with milions records. this file i have to fillter out based on the country, generate a file for each country.There are 60 countries and i need to generate 60 files from one single source file. Can anybody suggest the logic how to do. I want to know is there any restricatio...

Hi All, I have created the job to create a delta file. job is running and show finished but throwing the warnings, giving the wrong data in the output. I used two ftp stages change capture stage and a dataset. Change_Capture_7: When checking operator: Defaulting "TICKER6" in transfer from ...

Hello Everyone, I want to know how to remove the header and footer in datastage. I have to read a file and load the detail data in the target file. From source i'm getting the Header, detail and Footer records. I have to load only the detail records in the target. Is there any way how to fillter Hea...

Thanks Rich and Ray Hi Rich, I looked into the CDC stage and I think it is the solution for my job. Please let me know how to get the change records 1) when i have a single column as a key? 2) when i have complete record as the key ( is there will be any constrain on the column length). Thanks in ad...