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 |
what is the gap analysis?
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
What is the filename which you need to configure in UNIX while installing infromatica?
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is dynamic cache?
without using rank transformation how can we rank items by using some other transformations
What are the different lookup cache(s)?
if i have a delimited file as source so how can we seperate this file into three diff targets?
What is souce qualifier transformation it is active or passive
How can you generate reports in informatica?