Using Directory as Source to read all .txt files in the Directory
Could you please confirm the execution engine which is being used in mapping and please confirm , have you tried option available for flat files where the filename can be added to a port once imported using the Developer tool by going to Properties tab on the flat-file data object.
We are using Spark mode to execute the Mapping. Yes we are using flat file level option to add a port , problem is when we are using it with DIrectory as Source it is returning the Nulls in file name.
Data Viewer works in Native Mode always. Look at log file for Data View.
Next, as I remember, FileName Port for sources did not supported in earlier BDM versions. Please, check documentation for your version
Thank you all.
We cannot read the FLAT FILE name when reading from S3 in Spark mode. So we have changed the logic to read the data from Local (Informtica Server) & it is working fine.