top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Blank line in between each records in infomatica

+1 vote
586 views

I have a workflow which writes data from a table into a flat file. It works just fine, but I want to insert a blank line in between each records. How can this be achieved ?

posted Jul 29, 2013 by Deepankar Dubey

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

Create 2 target instances in which one will contain source data and other one will contain blank line.
In session properties set Merge Type as "Concurrent Merge".

answer Aug 18, 2013 by Shatark Bajpai
Similar Questions
+6 votes
Parameterization of Schema Names in Informatica

I have this query say

Select A, B from Language.Alphabet

Where Language is my Schema Name, this query is used in Informatica Source Qualifier. This query is in Dev at this point so as I go to QA and Prod, the schema name needs to be changed, so rather than going to the query all the time I would like to change the schema name from our scheduling tool DAC.

I tried to parametrize this in Informatica by creating a parameter file and placing it on Informatica server, I get the desired results from this but only if I execute the workflow from Workflow Monitor and not from DAC, but I want it to be done from DAC.

+5 votes
How to extract number from a string in Informatica?

I want to extract the number(0-9) from the string. e.g. if src is *Ax456*&56 then dst should be 45656.

+6 votes
Informatica - replace characters in target

Im working in a project which we create hundreds of xml's in informatica everyday, and all the data which is in the xml should be filtered, like removing all kind of special characters like * +.. You get the idea.

Adding regular expressions for every port is too complicated and not possible due the large amount of mapping we have.

I've added a custom property to the session XMLAnyTypeToString=Yes; and now i get some of the characters instead of &abcd, in their usual presentation (" + , ..).

I'm hoping for some custom property or change in XML target to remove these characters completely. any idea?

+1 vote
How to truncate a string in informatica based of size instead of length

How can i truncate a string in informatica based of size instead of length. My problem is i had to populate a VARCHAR2(4000) field but there are some special character in the data which have size of 2 byte.

So if there are 4000 character in a string and 10 are special character with 2 byte , then overall size becomes 4020 byte which is out of range of VARCHAR2. I had tried using VARCHAR2(4000 char) but even this is not working. I don't want to use CLOB.

What i am trying to achieve is that the string should have only 4000 BYTE of data. i.e in case of above example string should have only 3990 character and 4000 BYTE.

...