Load a date field value from sequencial file to databse table with out using Transformer

I have an input file in below format
Name DOB
------ ------
A 10-05-1990
B 07-12-2000
Q1 -> How we will load the above file data into a target data base table in a simplest method without using Transformer ?
Q2 -> How will load the Date column into 3 splitted columns(DD|MM|YYYY). Like below
Name DOB
------ -------
A 10|05|1990
B 07|12|2000

Questions by Aloka   answers by Aloka

Showing Answers 1 - 6 of 6 Answers

Gagandeep Singh

  • Jul 29th, 2016
 

Define delimiter as - in Sequential file stage

  Was this answer useful?  Yes

amulya panda

  • Aug 2nd, 2016
 

Use in transformer stage and use Ereplace(SOURCE_COLUMN_NAME,"-","|")

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions