top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to transform rows into column using Normalizer in Informatica?

+1 vote
2,264 views

How to transform rows into column using Normalizer in Informatica?

posted Aug 14, 2013 by Sumit Pokharna

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

1 Answer

+1 vote

http://www.dwbiconcepts.com/etl/14-etl-informatica/17-using-informatica-normalizer-transformation.html

Perhaps above mentioned URL will help you.

answer Aug 19, 2013 by Shatark Bajpai
Similar Questions
+1 vote
Rejected rows into a bad file, how to avoid that when using Informatica

I have developed an Informatica PowerDesigner 9.1 ETL Job which uses lookup and an update transform to detect if the target table has the the incoming rows from the source or not. I have set for the Update transform a condition

IIF(ISNULL(target_table_surrogate_id), DD_INSERT, DD_REJECT)

Now, when the incoming row is already in the target table, the row is rejected. Informatica writes these rejected rows into a .bad file. How to prevent this? Is there a way to determine that the rejected rows are not written into a .bad file? Or should I use e.g. a router insted of an update transform to determine if the row is insert row an then discard the other rows?

+2 votes
update a record in target table without using Update strategy using Informatica

How can we update a record in target table without using Update strategy?

+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.

+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.

...