Interested to Buy Any Domain ? << Click Here >> for more details...
how do u convert date in 20-12-07 to dec-20-2007 or 20-dec-
2007 or 20-dec-07 in parallel
- 3 Answers
- 9733 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / prasad
use column datatype as varchar
DateToString(StringToDate(DSLink3.DateColumn,'%dd-%mm-%2000yy'),'%mmm-%dd-%yyyy')
use above format in derivation for transformer stage, u will get the desired output.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
describe the Steps to confiure a Qlogic switch
Notification Activity
what is the use of materialized view?
Name the different sorting methods in datastage.
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is the difference between passive stage and active stage?
Can you explain players in datastage?
What are the partitioning techniques available in link partitioner?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is the purpose of interprocessor stage in server jobs?
How do u convert the columns to rows in datastage?
what is the use of skid in reporting?
Difference between server jobs & parallel jobs?
What is the use of datastage director?
