How i can upload the MainFrame source For Informatica ?
Answer / shiva
hi,
first take the .cbl files or copy books and import into
Informatica source analyzer. here you will get 2 metadata
structures like IN_ , OUT_ you can use any one as your
source datadefination in Informatica environment.
| Is This Answer Correct ? | 0 Yes | 0 No |
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
Why you use repository connectivity?
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
Explain what are the different types of transformation available in informatica.
How to eliminate duplicates in FF and oracle both
Suppose we do not group by on any ports of the aggregator what will be the output?
How do we implement materialized view?when to use materialized view?
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
Why we use partitioning the session in informatica?