Which transformation should we use to normalize the COBOL
and relational sources?
Answers were Sorted based on User's Feedback
Answer / swetha
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.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / usha
by using normalizer transformation we can normalize the
COBOL and relational sources.when ever we drag COBOL
soureces in mapping designer by default normalizer
transformation appears
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vikaskrmails@gmail.com
normalizer tr is specially used for Cobol sources because
its contains "Identified by" and "OCCURS" keyword that's
merge multiple record in one Normalized creates Generate-Key
and Genetrete column key for normalize it.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bsgsr
hi,
swetha
wud you mind clarifying some queries of mine.
my mail id is bsgsr12@gmail.com
| Is This Answer Correct ? | 0 Yes | 4 No |
Explain the tuning lookup transformation - informatica
I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?
How would you join a node to the already existing domain?
How do you load unique records into one target table and duplicate records into a different target table?
How can u work with remote database in informatica?did you work directly by using remote connections?
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
how to delete duplicate records by using filter transfermation?
How to view and Generate Metadata Reports?
where to store informatica rejected data?
suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?