DSXchange

Hi All

I searched a lot but could not find the right path.
so posting here
question is: how to get the count if file is source or if the source is table.
And also i need to get the target count.
I want to use these counts in the onther job.

Need your help on this..

thanks a lot..

hi all

Hi Guru's

I am facing fatal error when Iam using XML Out Put stage in the parallel job

fatal error:XML_Output_6,0: Caught unknown exception from runLocally().
XML_Output_6,0: The runLocally() of the operator failed.

Thanks in advance..

Regards
Siddu

Hello All

Could you please tell me how to check the WAS Server/Data stage Engine running or not by simple commands ??

Thanks a lot in Adv

Hi Ray

Thank u so much for your reply.

I am using the Country Rule set and Literal : US

Please let me know ...

HI all

I am standardizing the address, city,zip code and using 1 input file data and writing to out put file. and giving literal as US in the stage.but i am not able to get the result.

Any inputs please ........

Thanks in Adv

Hi DSsss Input is as below, with pipe delimiter. But In location field value there is chance of comming | as one of the character in the values. I want to pass as it is to target. I want to do this in sequential file stage only (no Tmf allowed) Please suggest Input NUM|LOCATION|STATECODE 10|MUM|BAI|...

hi

nothing much

i/p : 11100111000110

O/p should be : 11300114000120
Here we add number of zeros in front of 1 and +1 to that . thats it. Hope it clear now..
Thanks a lot for u r replay

hi

that 1 output only.... here plz refer....

i/p o/p
0 0
0 0
1 1
1 3
0 0
0 0
1 1
1 1
1 4
0 0
0 0
0 0

hi all

How to calculate this one. i mean after every number(not 0) equals Number+Number of Zeros in front of it.
For Ex: 3= 1+2 Zeros
4= 1+3 Zeros.

0
0
1
1
3
0
0
1
1
4
0
0
0
Thanks in Adv......

hi ALL

I have src as year col i want to do each year some calculation. And each year should reset the values.

please tell me how to do this one basicaly year separation from single column and reset the values from staging var ?

Thanks in Adv

Thanks Ray and Mike For your quick replay

Actuly In week either 7 days or 5 days, But i need to get total calendar weeks in a quarter let us say 1 to 12 for each quarter.and restart count if month jan,april,july and october.

HI All

Please tell how to get week number for each quarter?
Each quarter have 12 weeks.
1 quarter 1-12 week in no.
2 quarter 1-12 week in no ..etc

Thanks a ton in Adv

Hi thanks

But where to pass startvalue param and limit param in the row generator.
In options we can pass only #NoYears# param. In edit row also not possible to pass those 2 params. Plz.....

Sorry From Row generator stage its not possible to generates dates for variable number of years. Its only for fixed no of records can generate.