in source is like seq file in date column have
dd-mm-yy
dddd-mmmm-yyyy
mm-dd-yy
yy-dd-mm
yy-mm-dd
i want to display only yy-dd-mm date formats only in tgt?
- 2 Answers
- 8433 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / ram
hi,
before importing the metadata into the sequential file
convert the column datatype date to string, then use
transformer stage change it as stringtodate.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is the difference between == and eq in UNIX shell scripting?
Why do we use link partitioner and link collector in datastage?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
How many Key we can define in remove duplicate stage?
What are some prerequisites for datastage?
Which commands are used to import and export the datastage jobs?
Give an idea of system variables.
What is size of a transaction and an array means in a datastage?
How to reverse the string using unix?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What is ibm datastage flow designer?
What are the different common services in datastage?
What is the differentiate between data file and descriptor file?
