I am new to PDI and have extremely less knowledge on the use of all transformations.

I am trying to extract data from a HL7 input source and would like to load them into tables in SQL server. Below given is a sample of how my HL7 input would look like:

MSH|^~\&|ABC||ABDDEF||||ORU^R01|HP10000000|P|2.3||||||8859/1
PID|||MRN0XX^^^^MR~""^^^^PI~J00000000000^^^^VN||Giovinazzo^Carmine||19680101|M
PV1||I|ABCXXX^^BedXX&0&0
OBR|||572d3f14-31de-4fb8-bb1c-beaa7c5068fa|XXXX|||20140506091656|||demo^^^^^^^^^^^^^^^O~""^^^^^^^^^^^^^^^V
OBX||CE|0002-FA20^PrType^MDIL|128|F002-F01F^ABC^MDIL||||||F
OBX||ST|0002-FA21^Prot.^MDIL|128|Test Data||||||F

I have created a temporary table which contains all columns. So, basically i need to fit each data (pipe-delimited) into each column.

Not sure if this is a very simple question. Any guidance would be greatly appreciated!!