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
- 5096 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 is the difference between a table and the materialized view?
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
Without source how to insert record to target?
Can anyone tell me the new features in Informatica 9 Version?
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
How to create the source and target database connections in server manager?
Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc
How to delete first 3 rows & last 3 rows in target table in informatica
What do mean by local and global repository?
How to recover the standalone session?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
Teradata 
