Interested to Buy Any Domain ? << Click Here >> for more details...
In CSV flat file date are in the following format.
dd/mm/yyyy (05/01/2005)and
d/m/yyyy (5/1/2005) and
dd/m/yyyy (05/1/2005) and
d/mm/yyyy (5/01/2005). It should be load to target
in a unique format. How will you implement this?
- 1 Answers
- 5089 Views
- I also Faced
- E-Mail Answers
Answer / davankumar
To_char(date,formatedate) in the expression t/r
| Is This Answer Correct ? | 3 Yes | 0 No |
What exactly mentioned in High level design document.can somebody explain me sequentialy.
Normalizer transformation is not involved in Mapplet.. why???
write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
What is the main difference between a Joiner Transformation and Union Transformation?
What is olap (on-line analytical processing?
What is dimensional table?
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
What do you mean incremental aggregation?
Two different admin users created for repository are ______ and_______
Teradata 
