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
- 5809 Views
- AHM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Briefly describe lookup transformation?
What do you understand by SOA of Informatica?
What is the need of an ETL tool?
Which version configuration tool used in ur project?
What are the differences between oltp and olap?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is primary and backup node?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are connected or unconnected transformations?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How to update a particular record in target with out running whole workflow?
What is data caches/ index caches?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
