Interested to Buy Any Domain ? << Click Here >> for more details...
write asql query to filter improper date format?
date
20-apr
11-mar-2010
30-may-2010
feb-2009
i want the output
date
11-mar-2010
30-may-2010
- 2 Answers
- 6536 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prasad
The function appears like this IIF(IS_DATE(DATE, 'DD-MON-YY'),TRUE,FALSE)
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / gyana
u can use the TODATE() function to make it as default date
and time
| Is This Answer Correct ? | 2 Yes | 0 No |
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
what is a junk dimension ?
14 Answers Atos Origin, Cognizant, HS, NIIT, TCS,
Using Expression transformation how to remove duplicate records from a relational source?
What is meant by target load plan?
What are the advantages of informatica?
Did u used latest transformations of 8.6.0? for what?
What is intricate mapping?
What is option by which we can run all the sessions in a batch simultaneously?
How will u find weather dimension table is big in size of a fact table?
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
EXL informatica Questions
Teradata 
