top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Which transformation should we use to normalize the COBOL and relational sources?

+1 vote
306 views
Which transformation should we use to normalize the COBOL and relational sources?
posted Mar 7, 2016 by Sachin

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

2 Answers

+1 vote

Normalizer transformation which is used to normalize the data.
Since COBOL sources are often consists of De-normalized data. You can use only Normalizer transformation to normalize COBOL source

answer Mar 8, 2016 by anonymous
0 votes

Normalizer Transformation.When yoU drag the COBOL source in to the mapping Designer workspace,the normalizer transformation automatically appears,creating input and output ports for every column in the source.

answer Mar 8, 2016 by Manikandan J
Similar Questions
+1 vote
How to transfer data to the target table from multiple sources without using Joiner Transformation in informatica?

I have two sources (source A and Source B), source B is an another one target table in my db. both are in diff user id . Now i have to transfer some data,s from these two sources to target table. Can i transfer data without using the joiner transfermation? how to do ?

+1 vote
What are Difference between Relational Lookup and Flat File Lookup Transformation?

When you create a Lookup transformation using a relational table as a lookup source, you can connect to the lookup source using ODBC and import the table definition as the structure for the Lookup transformation.
where as When you create a Lookup transformation using a flat file as a lookup source, select a flat file definition in the repository or import the source when you create the transformation. When you import a flat file lookup source, the Designer invokes the Flat File Wizard.

I found an interesting article on this topic at below links , It quite descriptive

http://www.tecktricks.com/difference-between-relational-lookup-and-flat-file-lookup-transformation-in-informatica/

...