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
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain about cumulative Sum or moving sum?
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
What are data-driven sessions?
How do you load only null records into target?
what is index?how it can work in informatica
How many types of sessions are there in informatica.please explain them?
can u give example for factless fact table
Describe an informatica powercenter?
Describe data concatenation?
What is a surrogate key?
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
How can you validate all mappings in the repository simultaneously?
generate date / time dimension in informatica