DSXchange

i tried by adding new column Group and family in transformer and then tried by using the aggregator stage after transformer but unable to get the result.

chulett wrote:Cleaned up your example.

i apologise will take care

hi, i have three columns in seq file as follows but i need the out put int he following way .Two extra columns required as per requirement GROUP and FAMILY Name Phone_desc Phone_number GROUP FAMILY ABC work 123-456-789 1 Y XYZ CELL 857-657-798 2 N GHI WORK 123-456-789 1 Y IF NAME : ABC AND GHI havin...

Chullet,
Everytime job run and on each run if records rejected then email needs to be send one time for every run not for each individual rejectes records.

thanks Ray for your response

yes each time mail should be send to the recipient .

Hi,

i have a sequential file and i am inserting the records to the Target DB2 table and also have a reject link to throw out the rejected records.
I need an email when the records get rejected.How do i can do this in Datastage?

chullet,

i tried with suggestion provided but pivot not giving me the exact so i tried with alternate solution nut no luck.

i am more comfortable with pivot.

chullet,
can you give example as you told to hardcode before the pivot .Would you please elaborate this.

yes i am working on 8.7 version.,but i am not encounter with loop activity. Can you please explain again.I tried with the following in the tranformer before pivot stage loopvariable for description if @ITERATION = 1 then DSLink2.Cell_Number else if @ITERATION = 2 then DSLink2.Work_Number else DSLink...

in tranformer in am getting Name from input and pivoted data which contains Cell number,work number and home number. can you help me on this that should i add three new columns in output side cell,home and work number and then map pivoted to them. Can you please clarify me on this and if you give me...

Thanks Crig for response,

i tried using horizontal pivot and in derivation column given cell,home and work number but i am not getting the expected output.



Can you please tell me where i have to add new columns with hardcoded values.

Hi , I have sequential file with one record as source Name cell# work# Home# ABS 123 456 789 target output I required Name Phone Description phone # ABS cell 123 ABS work 456 ABS Home 789 Can anyone help on those.

If Trim(date_column) = '' Then StringToDate("12/31/9999",'%mm/%dd/%yyyy') Else StringToDate(date_column,'%mm/%dd/%yyyy') i have tried this function also but still getting the same error APT_CombinedOperatorController,0: Data string ' ' does not match format '%mm/%dd/%yyyy': an integer was...

Hi,

i am getting the source date field data like "15299 "and small int as datatype and want to convert to date format (yyyy-mm-dd).How can i convert .Which function i will use.Can you provide the whole function syntax.

i am getting the data in the format given below 20451,1,07/28/2006 30451,1,07/28/2006 80451,10,07/28/2006 70451,15,08/16/2006 60451,45, 34567,24.09/16/2006 this is csv file so second last date field have nothing just blank....can you help how can i handle this........now i am getting same warning wh...

file contains both Null and empty so i tried with function If IsNull(select.DATE) or select.DATE=' ' then SetNull() else StringToDate(select.DATE,'%mm/%dd/%yyyy') still thowing the same APT_CombinedOperatorController,0: Data string ' ' does not match format '%mm/%dd/%yyyy': an integer was expected t...