DSXchange

Yup,

Go to the table definition folder and double on the table definiton in format tab, check first column name and some other check box to apply for parallel job, finally load that definition into you stage.

Vijay

Hi,

Actually, it is not we could create dataset of size more 5GB. That too on each node.

Vijay

If you search vertical pivoting in the forum, you should able to find something. solution: use row process function in the transformer, which compares the previous with present row. If present value same as previous row value(customer id) then populate you input filed into their corresponding target...

I am sorry if I ask you more details. From experience, when you design PX job data type and there length are so important. Can you give more details like what are the data type output fields. Because once converted into decimal using StringToDecimal, you might want to do casting using Integer functi...

[quote="ashok"]help needed, How to remove characters in data containing like space, underscore, coma, period ect... and collect next letters example 1) John_Big is in comeing data and I need out put as JohnB 2) Tim,Jr the out put should be TimJr[/quote] Did you try to use change or ereplac...

hi , I am trying to create a LkP Fs..with about 21 million records..each of 36 bytes ..and my Job aborts saying that it has ran out of space after inserting 14 million records..now the resource space has about 254 GB free.. ..the exact error msg is : lkpfsWFccsiCISLPIDxref,0: Could not map table fil...