3.16 Source and Target Properties in IICS

[@rsmchittithalli7334]

Very informative

[@sadiyaahamed6034]

When using same table as lookup and target for truncate and load truncation is done before lookup can we alter this first lookup then truncation

[@itsranjan2003]

Workaround for this scenario : in target pre sql, insert the target table records into another table, use that table as look up. In this case trunacation of the table won't affect the lookup records.

[@karanrajkasat60]

I want to change the order of fields in betweeen transformation

[@ankitasahoo668]

if we have 10 columns in source but in target we need 2 columns only how do we do it

[@itsranjan2003]

keep two fields in the target object and map those two fields or exclude the required 8 fields in target object --> field rules-->incoming fields --> exclude fields.

[@gurnoorsinghdhanju2610]

Hi Sir, i need to use create a new option at target everytime..i have created an expression for a field, but i want to map that field to one of the existing column, how can i do that??? Plzz reply

[@itsranjan2003]

there is an option (create at runtime) in target properties. map the field there. so the target object can be created every time at run time based on the field value.

[@gurnoorsinghdhanju2610]

@@itsranjan2003 hi ranjan i am working in IICS..i have a column where i need to apply LTRIM, i created an expression for it. However i cannot assign the field which i created in expression to map the original column at the source.. i need to LTRIM one column and pass it to target… how can i do that? Plzz let me know if i can contact you on insta or Facebook for the same

[@itsranjan2003]

@@gurnoorsinghdhanju2610 hi, if you have created one output port in expression, this field will be visible in the target transformation input field list, then map the field, it's so simple, if you want to know how to do this, please watch my video on expression transformation. And please watch all videos in sequence to get a very good understanding of iics.

[@gurnoorsinghdhanju2610]

@@itsranjan2003 hi ranjan i am creating a new file at runtime everytime…which is why the field mapping option is not available. Using a gcs bucket at target.

[@PradeepKanaparthy]

Hi sir, if we paramterize source tranformation with connection paramter, object parameter, then incoming field won't be there then how can we transform the data in this case if we want to change date format? is there any we can do both paratmerize and transform the data?

[@itsranjan2003]

use the hard coded connection value, update the date format, validate it, then parameterize the connection/object again.

[@PradeepKanaparthy]

@@itsranjan2003 super sir. It worked! Thank you