DSXchange

Chulett and Ray, Thank You for your inputs. The Job which we are using is generic and we are using RCP. Hence,we don't have specific metadata in the jobs to convert the timestamp to a String at job level. Besides, to Answer Ray, We tried using the TZ environment variable,however, we didn't get the e...

Hi All, Could you please help me in providing your solution for the below scenario: We are using Oracle table as source and we have the date format coming from the source as below. 01-JAN-00 12.00.01.000000000 AM -5:00 We are trying to load the date format as it is including the timezone into a flat...

Hi , I have a mainframes data files(EBCIDIC) with header/detail/trailer data where in header and trailer has record types to identify them and segregate in complex flat file stage. The detail record type does not exist (confirmed by customer). I tried with fixed & single record type options in c...

Thank You everyone for the valuable notes . I am sure this post is going to help lot of people who want to take up 8.5 Certification,including myself:)

Hi Everyone, We are having an issue while loading the data from source mainframe file to netezza database. We are reading data in EBCDIC format and we are able to see the data in the view according to the requirement. However,when we try to load the data to netezza, it gave error as "bad rows l...

there is no specific key to group the records.whatever records are coming from input ,they are to be grouped on the input basis only. I have not registered as a premium user,hence i could not see the remaining part of your message. in your next reply, can i request you to post your replies in normal...

Hi everyone, I have a requirment where in i have a source dataset having the records and we have to group the source records into groups of five each and process these groups of records in the further steps. Can someone please suggest if we can achieve this through aggregator stage and if so, the st...

Thank you the suggestions. I may not be clear in the requirement. I accept that we can get all the fields into a stage variable by using concat .However, I wanted to get these fields into the output as field by field instead of a single stage variable getting into one field. Means,we need to get the...

Thank you for your input.However, my requirement is to consider the whole input row and compare with previous row. I have done scenario where I pick up few fields(previous and current) and do transformations based on previous ,however, picking up a whole record into a transformer is something I didn...

Hi everyone,

I am using a dataset as a source file. Can someone please suggest how to retreive a previous record with reference to the current record in the file.

Thank you in advance.

Hi team, I have a requirement as below: could you please help me in this: we have a file which has the records coming in where the file has the source fields as well as the fields retreived from a lookup.For easier identification, I mention the set of source fields as S and set of retreived lookup f...

Yes Craig. I have seen few posts ,however, I could not find the exact solution as the answers are not the sure shot ones for those I have seen. Hence I have posted. request for your reply please...

Thank you so much

Hi Everyone,

could you please suggest how to get the spaces converted to hex 000c.

I guess I can use convert function ,but I am not sure of what values to be passed for the hex 000c. I suppose it is char(20) for spaces.

Hi Everyone,

We have a requirement where in we have to include matching and non matching row counts into the body of the email notification stage.

Could you please suggest is there a way to acheive this.