Plz..let me know differences between Informatica 7.1 and
8.1?

Answer Posted / rajendra

I know only few difference

7.1:Java is not supported
No java source qualifier
8.1:Java is support
java source qualifier
Report generators(Not sure)

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

595


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6390


Explain about cumulative Sum or moving sum?

614


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1395


What are data-driven sessions?

709






How do you load only null records into target?

732


what is index?how it can work in informatica

1574


How many types of sessions are there in informatica.please explain them?

668


can u give example for factless fact table

5505


Describe an informatica powercenter?

602


Describe data concatenation?

563


What is a surrogate key?

555


1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

3757


How can you validate all mappings in the repository simultaneously?

750


generate date / time dimension in informatica

711