1)what is the use of bottlenecks in informatica.
2)where we are use shellscripting.
3)what meant by informatica.
- 1 Answers
- 6529 Views
- CTS, I also Faced
- E-Mail Answers
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 can you define a transformation? What are different types of transformations in Informatica?
4 yrs etl devloper roles and responsibilities?any body give solutions
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?
Which is the best place to learn Informatica Powercenter Online Training?
Explain reference cursor?
How to open an older version of an object in the workspace?
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
How to find from a source which has 10,000 records, find the average between 500th to 600th record?
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
 Code page compatibly –Where all changes are made to handle the scenario.
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Explain the informatica workflow?
Teradata 
