Hello All, Please help me to Improve the Performance writing the data using with CFF stage . I have designed my job as below. Source DataSet--->Transformer--->Target - CFF (Complex Flat File) This Job processing on Node 4 ,and there are 150 Fields in the Target . It is processing 4400 records per se...
All, I am trying to extract the data from .dat file. I am getting ASCII Data file from Mainframe and it contains 7 records.I am unable to view 3 records. I am using below selections in Complex Flat File stage in PX Record Type : Fixed Data Format :Txt Characterset :ASCII Can you explain me what are ...
ray.wurlod wrote:You can get days between two dates (DaysFromDateSince() function). The rest should be arithmetic. However, you need to document your business rules thoroughly, and will probably need a custom functi ...