See the following link, Its very helpful for beginers
They have provided very nice information about the functions and there are many link which points to examples. Even they have given it diagramatically.
say in case you have two fields firstname and lastname and in your target you need the full name then u can use the concat function and avoid writing a UDF to concat both the text. Similarly in case you want to extract only the first 3 letters of a field in the source and map it to the target, then u can use substring etc.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.