Which transformation should we use to normalize the COBOL
and relational sources?
Answer Posted / 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 |
Post New Answer View All Answers
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How we can create indexes after completing the load process?
What is sorter transformation?
What is sequence generator transformation in informatica?
How to load the data from a flat file into the target where the source flat file name changes daily?
Can we override a native sql query within informatica?
What is meant by lookup transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Under which circumstances, informatica server creates reject files?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Explian the Process of deployment groups in informatica
permutations of mapplet
Repository user profiles
What are the differences between oltp and olap?
What all join we can perform in LOOKUP transformation?