I have pipe delimited source file,but has some records which has large value so it comes in a new row.BUt since in informatica row delimiter is \n,it takes the next line also as a new record and this is where the mapping fails,can anyone help me to know what row delimiter should i selct in flat file properties to avoid this situation.
Is it Unix or Window? If it is unix based, then you can create a script , that will fetch the required row(use 'echo' command to throw the row). Call this script in the session level(under flat file sesion property--> command).
Can you please explain more specific on your requirement?If you have pipe delimted as a source file then you can provide | as a delimiter in the source properties.
How the records are splitted into two rows.It is because of some /n character in betweem of the records.
Replace the \n with '' so that informatica wont split the records into two.Use the below logic in the mapping which is producing the flatfile to remove the linefeed in the column
REPLACESTR(TRUE,Columname, chr(10), '')
In source file the delimiter (\a).In the session properties in the file delimiter i have also specified the same delimiter as (\a).
But even then while loading the file whenever there is \n it takes it as a new record.
.When i was trying to import this source file,the delimiter (\a) is not identified ,it imports everything even the data as the header.
Informatica will split the records into new record whenever it encounter \n value in a feild.
Could you please post the source file if possible.You have to remove the \n in the source file before processing into informatica.
May be use some scripts in the presession command to remove all the \n in the file and then process the records in informatica
Create a script which replease "\n" character in your file with any other character (for this you can SED commands)
call this script processing the source file.
Arun Gupta .