Interested to Buy Any Domain ? << Click Here >> for more details...
How to write a procedure for a date which is in three
different formats,and you want to load into datawarehouse in
any single date formate
- 2 Answers
- 6685 Views
- AHM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vaibhav bhandeo
Use to_date function in an expression. This will allow you
to change any date's format into other one.
Ex:
to_date('070903', 'yyyy/mm/dd') would return a date value
of 2003/07/09.
to_date('20020315', 'yyyy/mm/dd') would return a date value
of 2003/07/09.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ravi
if u can write decode function
decode((true,Is_date(culm_name,MM/DD/YYYY HH:MM:SS AM'),
to_date(clum_name,'MM/DD/YYYY HH:MM:SS ')
sysdate)
u can write multipul date formats in is,to date functions
otherwise it will return sys date
| Is This Answer Correct ? | 0 Yes | 0 No |
without using emailtask how will send a mail from informatica?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are connected or unconnected transformations?
In a sequential batch can you run the session if previous session fails?
What do you understand by a term domain?
Can you copy the batches?
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?
What is the difference between procedure and stored procedur?
How the dimensions will be loaded?
Differentiate between a repository server and a powerhouse?
in what type of scenario bulk loading and normal loading we use?
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
Teradata 
