DSXchange

Could you please be more specific.I am new to datastage. My data has Address feilds. ex: StreetNo AptNo .These are tab delimited.When I took at the Teradata report.This feild appears as 1 feild separated by Tab.I guess when it is writing to the flat file it is considering as 2 lines. Street No Apt N...

My source teradata Ent prise stage. and out put is sequential file.I have a table whose row count is 6 million .I have to extract this data and write it to a tab-delimited file flat file. when the write the data on to a flat file I am getting 30 more rows. while my DSjob shows 6 million records. as ...

When I try to remove the Group key.I get an error on the aggregator stage saying that Group key not determined.Can you please tell me how can I get the sum of columns with out the Group key?

Could you please be more specific?.My source is SQl and target is a flat file.I have to extract the data in to the flat file and sum the records on some particular columns.The data should be written on one flat file and the sum of records on columns should be written to 1 more file.I am able write t...

I have a file with 50 million records.I want to calculate the sum of rows in a particular column.I can do this aggregator but as per my knowledge I know that I can do that based on key .How can I calculate the sum 50 million records which has no unique key. I have to calculate the sum of all the rec...