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
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.
to_date('070903', 'yyyy/mm/dd') would return a date value
to_date('20020315', 'yyyy/mm/dd') would return a date value
|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 ')
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|
what is degenerated dimension
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
What is power play plug in?
what are presession,postsession success and postsession failure commands ?
What are the types of maping in Getting Started Wizard?
Define mapping and session?
Differentiate between Load Manager and DTM?
what is size of u r database?
What is the meaning of up gradation of repository?
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
Explain what are the different types of transformation available in informatica.
how will compare two mappings in two different repository?