1)what is the use of bottlenecks in informatica.

2)where we are use shellscripting.

3)what meant by informatica.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data caches/ index caches?

609


How to create a non-reusable instance of reusable transformations?

674


Under which circumstances, informatica server creates reject files?

589


How we can create indexes after completing the load process?

607


How can we update a record in the target table without using update strategy?

649






COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1527


What is pmcmd command?

668


What is native users?

717


How do we call shell scripts from informatica?

591


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?

1743


Briefly define reusable transformation?

620


What are the types of caches in lookup?

564


What does “tail –f” command do and what is its use as an Informatica admin.

625


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1964


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

624