1)what is the use of bottlenecks in informatica.
2)where we are use shellscripting.
3)what meant by informatica.
Answer / urs
1) Following are the some of bottlenecks in informatica..
(i) source bottlenecks
(ii)Target bottlenecks
(iii)Mapping bottlenecks
(iv) system bottlenecks
3)Informatica is one of most popular ETL tool...it will extract the data from the different sources and it will transform the data as per business logic and then it will load the data into different targets..
| Is This Answer Correct ? | 1 Yes | 0 No |
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
Explain sessions?
can v update d records in target using update stargey without generationg primary key ? explain
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How to view and Generate Metadata Reports?
Separate from a database, an information bazaar, and an information stockroom?
how to declare array in plsql?
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?
where to store informatica rejected data?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to load a relational source into file taget?