DSXchange

Sure Ray, I will plan to take a premium membership.

Anyone can suggest me with some ways to accomplish this.

Thanks,
Freddie

Hi Ray, Thanks for your quick response. As I read ur reply it looks like passing files dynamically & doing a field by field comparison is faesible in Datastage. But, since I am not a premium user, i was not able to read the latter part of your reply. Hope you can help me with some more details o...

Hi All, Thanks for visiting this post. I am looking forward to get some thoughts/inputs on a scenario where I need to build a Generic Datastage job to compare 2 files with same layout (field to field comparison) & generate a file similar to below. e.g: File1 File1 File2 File2 Field1(matched) Fie...

Hi All, Seek your thoughts on a design. I am trying to retire a MF Extract process which extracts data from DB2 table based on some inner joins with other tables & 12/13 datatype conversions (like CHAR(COALESCE(T.fieldname,' '),7) for a set of fields. Can you pls let me know whether I can put th...

Thanks Ray for your inputs :) The change capture/Apply seems to work. The new question that is arising in my mind is on the performance of these stages. In the Full File, we have around 500 million records. The delta file contains 10 million (Daily). I am hearing that the change capture/change apply...

Hi All, I have a requirement where I need to first capture the changed records when compared with a full file & daily delta. (Both are datasets). Also, once the changed records are identified, these records need to be updated back to the Full file to keep it current & up-to-date. Can you pls...

Hi All, I am coding for a requirement where I need to split the input records based on the no:of records with the same value for a Field A. When the no: of records with the same key value exceeds 6, then it needs to split into 2 groups & assign a new group value. That is, if the no: of records w...

Hi All, I am creating a statistics report after the ETL cycle run & I am currently attaching this report through the email notification & sending it to stakeholders. Is there a way I can send the content of the report in the e-mail body itself? I browsed through the forum for an answer &...

Thanks for your reply Kryt0n.

Pls note that I am building this report through a LINUX Shell Script. ( & not through Filestage in DS). Wondering whether we can add DOS line terminator in Script level too.

Thanks
Freddie

Hi Chulett,

Thanks for your reply.

I googled for more info on DOS line terminators, but couldnt find any info on the same. Can you pls shed some light on this.

Thanks
Freddie

Hi All, I am trying to attach a .txt & .html (in 2 different e-mail notification activity). The files look in good format (like below) when i ftp'd & opened with notepad. Process Date : 20120308 Total Adds : 0 Total Changes : 0 Total Deletes : 0 Total Suspects : 6880 But when the email notif...

Hi All, I know my question is more of a LINUX command, but i thought i will check in this forum as I have seen lots of guys around with plenty of Scripting knowledge. Here is the situation: I have a file coming from MF every Sunday & my Master Sequencer runs any date between Tuesday to Friday of...

Thanks for your reply Ray.

Any thoughts from anybody who did experience something similar in QS 8.5 with the maximum no: of match passes ?

Thanks,
Freddie

Further to add, I am using IIS 8.5 version.


Thanks for your thoughts.
Freddie

Hi All, I am trying to understand the Maximum Number of Match Passes in the Match Specification. I have 15 match passes in this match specification, while checking the logs, I could see the Match Statistics is captured only for the first 11 match passes. Is there any limitations on the maximum no: o...