DSXchange

its not huge data. I am testing on only 12 rows, I have waited for 20 mints.

yes i did. its going out of aggregator stage but not comming out of pivot. Its hanging there.

Thanks ray for quick response.

ya there are two entries for jan and i need both the records to be aggregated as single record . i tried using agrregator stage before pivot stage. But the job just hangs and is not proceeding further after aggregator stage.

Hi, I have i/p as id date gp code amt 1 1992-01-01 US abc 123 1 1992-01-01 US abc 124 1 1992-02-01 US abc 234 1 1992-03-01 US abc 245 Expected o/p id gp code jan feb march april june july aug sept oct nov dec 1 US abc 247 234 245 i used pivot stage and type as vertical pivot . group by by id,gp,code...

Hi I have a requirement where i need to schedule jobs once a month. And if the day falls on weekend then i need to run the jobs on monday. For this i chose the below approach . we have a date dim table and i am comparing current day with isodate in date dim and getting the day and writing into a csv...

Thanks All. Yes there was a bad data from source which is not matching the metadata.

source is sequential file. Every time when i run it show a different record . No NLS characters from source. Basically my job has 4 sequential files funneld to write to a sequential file as below.

Hi Chullett, I have tried possible ways but still i see the warning. i see both of these warnings together, no idea what the problem is. Is there a way that we can check record 248719? Import consumed only 205bytes of the record's 208 bytes (no further warnings will be generated from this partition)...

Hi,

I am getting below warning. Any suggestions?

Import consumed only 205bytes of the record's 208 bytes (no further warnings will be generated from this partition)

Thanks

My target is date datatype. i can use which ever possible way through datastage or writing sql. I wanted to write logic in datastage but then i thought its complicated and choose to write sql.
my source is AS400

Hi Chulett,

i tried this logic while extracting from source table date(timestamp_format(char(DTE+19000000), 'YYYYMMDD')) DTE and date as datatype
but it is throwing a warning as Expecting:symbol of type:date_string

Thanks

may i know the exact function to be used to add ?

Hi Chulett,

yes these are real dates comming source.

i am expecting o/p as

Target
id dte
1 2000-07-28
2 1996-09-12

Hi,

I have a scenario where i need to convert decimal to date:

Ex: id dte
1 1000728
2 960912


Target

id dte
1 yyyy-mm-dd
2 yyyy-mm-dd


Any suggestions?

Thanks

Hi Can any one help me with this scenario. I have current date, If current date falls in between yyyy-mm-02, ! ! !yyyy-mm-05 of month then get the last date of previous month. for ex:current date =2013-07-02 then i need to populate as 2013-06-30 simillarly if date falls as 2013-07-03 then also its 2...