DSXchange

when there are no records ,i want to capture the current timestamp.

Hi,

i feel that if i do a count(*),i am going to get the Record count Right ..?

and also i need the Current time stamp....not the record count,could you please explain clearly as i am stuck..

Hi ,
cant i incorporate in the same Job.

Hi, i Want to Capture the time stamp from a Sql database,when the table Delivers '0' Records. My Path is : ODBC ====> Copy======> Seq File Currently i am able to get the "time-stamp" recorded in the Seq file when there is data in the table,so my Questiosn is How can i get the "Time-st...

Ok,will include it in the Aggregator stage.

Hi Hendrikb,

for group1 this is the output i am expecting :
5001 AAT 1230 1 jan06 0.99
5001 AAP 2437 1 jan06 0.89

Hi all, Here is the sample fields and Data : Buss unit | Cust code| product key |Seq no |Billing Date | Amount| 5001 AAT 1230 1 jan06 0.12 5001 AAT 1230 1 jan06 0.87 5001 AAP 2437 1 jan06 0.89 6161 AAP 2437 2 feb02 -128.27 6161 AAP 2437 2 feb02 12.32 7652 AAT 2437 3 feb02 8.76 7652 AAT 2437 3 feb02 ...

Hi Kandy,
the 6th field is not a constant field for "4 keys" by which i aggregate the AMOUNT.

Hi All, i have a Requirement. Please Advise me on the Job flow. i have 6 fields from a Dataset output and from these 6 fields,5 fields are part of Aggregator i.e; one among the 5 fields is Amount which is calculated based on the Sequence of other 4 fields. I can use these 5 fields in the Aggregator ...

Hi ALL, the length of the hard-coded character i.e; TRAILERRELIARTOWSFRWC is Char(120).But earlier i didn't specify the Length in Dev. so i made this change in Dev now i.e; Specified the Exact Length i.e; Char(120) and migrated to QA. Now it is working fine in QA ( i.e; i Don't see 3 Additional Rows )

Hi,
i did compare the Hardcoded characters and it looks same.

Hi Chulett,
it runs on a single Node.

Here is the Config file:

dsQ:'$APT_CONFIG_FILE'=/ford/thishost/proj/Ascential/DataStage/Configurations/FEDW_SOWSQAdefault.apt

Hi All, i am populating a Record which is hardcoded as "TRAILERRELIARTOWSFRWC". When i run this in Dev i get output as TRAILERRELIARTOWSFRWC (which is correct) But recently i migrated the code to QA & when i test it in QA then i get TRAILERRELIARTOWSFRWC and also there are 3 more rows ...

Hi Roland,

i deleted the Dataset files manually...

Now i started creating the dataset freshly,earlier i am using a wrong Config file,Now i changed it to point to correct one.

So Now it works...

Thanks....

Hi All, i am running an extract job to load Data into a Dataset...from a Sql table. i am getting this error,please Help me :- "The file identified as '/ford/thishost/proj/Ascential/Projects/FEDW_DEV/interimfiles/ows/PPLGL_002_1.ds' is not an ORCHESTRATE Data Set descriptor." till last week...