PDI - Loading CSV File to Table

                     Hi guys, let us follow the simple steps to load a csv file to a table and the vice versa.

Step 1 : Drag the text file input to the workspace.

Step2: Double click on the file input and give the proper values for the tabs.

 Step 3: After given the values , click get fields to get all the fields from the file.


Step 4: Then, drag the table output and link the input and output.

 
Step 5: Give all the db credentials in connection box and give the field names.

 

 
Step 6: Then run the transformation, data will be loaded into the table.

 

Thanks.
Queries are highly appreciated....
Dilip Yadav S