hello friends this ashok,
actually requiremnt in the target field id dd/mm/yyyy , while the soucre filke has same format dd/mm/yyyy.but job gets succeded,no data in target
any one can give me a solution in date formats
regards
regarding date conversion into dd/mm/yyyy
Moderators: chulett, rschirm, roy
Welcome aboard. What is your target stage? Is it ODBC, OCI, etc? What database and version. Can you tell us the datatype of the column in question? "No data in target" means no rows, or empty columns? Are there any messages in the job log?
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Hello Asoka,
this is a common type of transformation; but before anyone can suggest an answer you must tell us what the target database is going to be. You can also look up the documentation for the ICONV and OCONV functions and the "D" conversion code and also use the search facility shown above to get some preliminary answers.
this is a common type of transformation; but before anyone can suggest an answer you must tell us what the target database is going to be. You can also look up the documentation for the ICONV and OCONV functions and the "D" conversion code and also use the search facility shown above to get some preliminary answers.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
i am using sequential file as source and odbc stage as targt
hello friends,
I am using sequential file as soucre, odbc as target and target database is oracle 9i.
sample of source file as fallows
516022.00000|party instrution |06/02/2002| 50096| 8905.00|vijay automobile |06/02/2002
518756.00000|party's request |25/01/2002| 50474| 45832.50|landmark leather |23/01/2002
513127.00000|PARTY'S REQUEST |16/01/2002| 51441| 1760.00|SURSANGAM |28/02/1900
468820.00000|AS PER PARTY'S REQUE|08/01/2002| 50096| 13503.00|JAGANNATH K B |22/10/2001
459425.00000|misplace |29/12/2001| 51376| 0.00||28/02/1900
459424.00000|misplace |29/12/2001| 51376| 0.00||28/02/1900
459423.00000|misplace |29/12/2001| 51376| 0.00||28/02/1900
459422.00000|misplace |29/12/2001| 51376| 0.00||28/02/1900
459421.00000|misplace |29/12/2001| 51376| 0.00||28/02/1900
459420.00000|misplace |29/12/2001| 51376| 0.00||28/02/1900
459419.00000|misplace |29/12/2001| 51376| 0.00||28/02/1900
459418.00000|misplace |29/12/2001| 51376| 0.00||28/02/1900
514963.00000||29/12/2001| 51441| 945.00||28/02/1900
27365.00000||**/**/****| 0| 0.00||**/**/****
275365.00000|refer to drawer |**/**/****| 8239| 1000.00|M/S MAXCOM |**/**/****
202480.00000|chq book lost |21/10/2000| 8160| 0.00||28/02/1900
202479.00000|chq book lost |21/10/2000| 8160| 0.00||28/02/1900
202478.00000|chq book lost |21/10/2000| 8160| 0.00||28/02/1900
202477.00000|chq book lost |21/10/2000| 8160| 0.00||28/02/1900
(dos style file,it has seven fileds )
source fildes target fields (datatypes)
filed1 chqueno Number(15)
filed2 stoppayreason varchar2(30)
filed3 stoppaydate DATE
filed4 accountno NUMBER(6)
filed5 Ammount Number(18,2)
source fileds 6,7 are excluded
while filed3 in source table is dd/mm/yyyy format and the same i need in the target date filed.
i know that there are some valuess **/**/**** in sorce fileds, could i "replace by some dummy dates example where ever **/**/**** comes then i have to replace with 01/01/2010 "
is this posible in datastage
regards
I am using sequential file as soucre, odbc as target and target database is oracle 9i.
sample of source file as fallows
516022.00000|party instrution |06/02/2002| 50096| 8905.00|vijay automobile |06/02/2002
518756.00000|party's request |25/01/2002| 50474| 45832.50|landmark leather |23/01/2002
513127.00000|PARTY'S REQUEST |16/01/2002| 51441| 1760.00|SURSANGAM |28/02/1900
468820.00000|AS PER PARTY'S REQUE|08/01/2002| 50096| 13503.00|JAGANNATH K B |22/10/2001
459425.00000|misplace |29/12/2001| 51376| 0.00||28/02/1900
459424.00000|misplace |29/12/2001| 51376| 0.00||28/02/1900
459423.00000|misplace |29/12/2001| 51376| 0.00||28/02/1900
459422.00000|misplace |29/12/2001| 51376| 0.00||28/02/1900
459421.00000|misplace |29/12/2001| 51376| 0.00||28/02/1900
459420.00000|misplace |29/12/2001| 51376| 0.00||28/02/1900
459419.00000|misplace |29/12/2001| 51376| 0.00||28/02/1900
459418.00000|misplace |29/12/2001| 51376| 0.00||28/02/1900
514963.00000||29/12/2001| 51441| 945.00||28/02/1900
27365.00000||**/**/****| 0| 0.00||**/**/****
275365.00000|refer to drawer |**/**/****| 8239| 1000.00|M/S MAXCOM |**/**/****
202480.00000|chq book lost |21/10/2000| 8160| 0.00||28/02/1900
202479.00000|chq book lost |21/10/2000| 8160| 0.00||28/02/1900
202478.00000|chq book lost |21/10/2000| 8160| 0.00||28/02/1900
202477.00000|chq book lost |21/10/2000| 8160| 0.00||28/02/1900
(dos style file,it has seven fileds )
source fildes target fields (datatypes)
filed1 chqueno Number(15)
filed2 stoppayreason varchar2(30)
filed3 stoppaydate DATE
filed4 accountno NUMBER(6)
filed5 Ammount Number(18,2)
source fileds 6,7 are excluded
while filed3 in source table is dd/mm/yyyy format and the same i need in the target date filed.
i know that there are some valuess **/**/**** in sorce fileds, could i "replace by some dummy dates example where ever **/**/**** comes then i have to replace with 01/01/2010 "
is this posible in datastage
regards
Yes it is possible.
Sounds to me you lack basic training in DS or had one to long ago without using it .
It would be better if your manager got some DS training for you or some mentoring by a skilled person.
This is only My Humble Opinion.
Sounds to me you lack basic training in DS or had one to long ago without using it .
It would be better if your manager got some DS training for you or some mentoring by a skilled person.
This is only My Humble Opinion.
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
regarding date conversion into dd/mm/yyyy
Hello friend,
I had done it using oracle stage, by using after option in that stage and converted it ,by using to_date function
regards
I had done it using oracle stage, by using after option in that stage and converted it ,by using to_date function
regards
roy wrote:Yes it is possible.
Sounds to me you lack basic training in DS or had one to long ago without using it .
It would be better if your manager got some DS training for you or some mentoring by a skilled person.
This is only My Humble Opinion.
Hi,
We ment you do a:
DB > xfm > target
job design where you use the Iconv/Oconv conversion in the xfm (Transformer stage) in the column derivations.
IHTH,
We ment you do a:
DB > xfm > target
job design where you use the Iconv/Oconv conversion in the xfm (Transformer stage) in the column derivations.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org