These flatfiles have employee information based on each department Also the number of files or departments is not know in Advance. load the database employee table with the information in the form of flatfiles received from source systems. A new port or column FileName with string datatype is created. On the right-hand corner click the icon Add FileName column to this table.
Click on Advanced Flat file information and set the Column Delimiters as ,.Change the desired Flat file information fields.Rename the Select table to FF_EMP_DEPTNO.Next Edit the target definition as follows. Next open the Target Designer.Select the EMP table, from the Sources of your Informatica folder found on the Repository Navigator.Just drag and drop the EMP table to the Target Designer.Select Source Analyzer and Import the Relational database table emp.That is, for each and every department we will generate flatfiles in a dynamic manner from our employee database table (we won't have to know how many departments we have beforehand). Generate respective flatfiles containing employee information for each department.
0 kommentar(er)
