Answer / shashiall

DIFFERENCE BETWEEN INFORMATICA 7.1 AND 8.1
===========================================

Object Permissions*

Effective in version 8.1.1, you can assign object
permissions to users when
you add a user account, set user permissions, or edit an
object.

*Gateway and Logging Configuration*

Effective in version 8.1, you configure the gateway node
and location for
log event files on the Properties tab for the domain. Log
events describe
operations and error messages for core and application
services, workflows
and sessions.

Log Manager runs on the master gateway node in a domain.

We can configure the maximum size of logs for automatic
purge in megabytes.

Powercenter 8.1 also provides enhancements to the Log
Viewer and log event
formatting.

*Unicode compliance*

Effective in version 8.1, all fields in the Administration
Console accept
Unicode characters. One can choose UTF-8 character set as
the repository
code page to store multiple languages.

*Memory and CPU Resource Usage*

You may notice an increase in memory and CPU resource usage
on machines
running PowerCenter Services.

*Domain Configuration Database*

PowerCenter stores the domain configuration in a database.

*License Usage*

Effective in version 8.0, the Service Manager registers
license information.

*High Availability*

High availability is the PowerCenter option that eliminates
a single point
of failure in the PowerCenter environment and provides
minimal service
interruption in the event of failure. High availability
provides the
following functionality:

*Resilience. *Resilience is the ability for services to
tolerate transient
failures, such as loss of connectivity to the database or
network failures.

*Failover. *Failover is the migration of a service process
or task to
another node when the node running the service process
becomes unavailable.

*Recovery. *Recovery is the automatic or manual completion
of tasks after an
application service is interrupted.

* *

*Web services for Administration*

The Administration Console is a browser-based utility that
enables you to
view domain properties and perform basic domain
administration tasks, such
as adding domain users, deleting nodes, and creating
services.

*Repository Security*

Effective in version 8.1, PowerCenter uses a more robust
encryption
algorithm.

Also provides advanced purges for purging obsolete versions
of repository
objects.

*Partitioning*

There is database partitioning available. Apart from this
we can configure
dynamic partitioning based on nodes in a grid, the number
of partitions in
the source table and the number of partitions option. The
session creates
additional partitions and attributes at the run time.

*Recovery*

The recovery of workflow, session and task are more robust
now. The state of
the workflow/session is now stored in the shared file
system and not in
memory.

*FTP*

We have options to have partitioned FTP targets and
Indirect FTP file
source(with file list).

*Performance*

Pushdown optimization

Uses increased performance by pushing transformation logic
to the database
by analyzing the transformations and issuing SQL statements
to sources and
targets. Only processes any transformation logic that it
cannot push to the
database.

*Flat file performance*

We can create more efficient data conversion using the new
version.

We can concurrently write to multiple files in a session
with partitioned
targets.

One can specify a command for source or target file in a
session. The
command can be to create a source file like 'cat a file'.

Append to flat file target option is available now.

*Pmcmd/infacmd*

New features added to pmcmd. We can use infacmd to
administer Powercenter
domains.

Infasetup program to setup domain and node properties.

*Mappings *

We can now build custom transformation enhancements in API
using c++ and
Java code.

We can use partition threads to specific custom t

Answer / infa

The main diff is in the architecture of the tool. In 8.1
you now have the server-node technology where ur job can
run on multiple nodes and the informatica server directs ur
process to any of the nodes

Answer / sivakumar

1.in 7.1 userdifined function are not there
1.from 8.1on words userdifined function are there

Answer / maruzthi

IN BRIEF MAIN DIFFERENCES ARE
1.)PUSHDOWN OPTIMIZATION
(HERE YOU CAN PUSH TRANS LOGIC TO BE DONE IN THE SOURCE
OR TARGET DATABASE,SO THAT WE CAN PREVENT THE DATA TO CAME
OUT OF THE D.B LOGS)
2.)USER DEFINED FUNCTIONS LIKE
I.)REGULAR EXPRESSION.
II.)FINANCIAL.
III.)ENCODING
SUCH FN ARE OF TWO TYPES
1.)PRIVATE-ONLY CALLABLE FROM OTHER USER-DEFINDED FN
2.)PUBLIC-CALLABLE FROM ANY OTHER TRANSFORMATIONS FN.
F.F ENHANCEMENTS-OPTIONS FOR MERGING TARGETT PARTIONS
3.)IMP-INF-8 IS A SUBJECT -
ORIE`````````````````````````````````````````````````````1

Answer / surya

Its very nice explination.
But i am afraid to say that, its posted only half. because,
at the end (i think its not the end) might be more mater.
can you re-post the answer in 2 or 3 parts. so that we can
have full information. (i am in bit more need of this, if
possible can you post it to call_surya@yahoo.com)

Thanks in Advance,

Answer / ramesh

same

what is filelist concept in informatica

4 Answers  

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,

What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 Answers  

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 Answers   Amdocs,

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers   BirlaSoft,

What does update strategy mean, and what are the different option of it?

0 Answers  

Clarify the aggregator change?

0 Answers  

whether Sequence generater T/r uses Caches? then what type of Cache it is

7 Answers   Accenture,

what is data modelling? what are types of modelling?In which suituation will use each one?

1 Answers   Accenture,

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,

why we use stored procedure transformation?

4 Answers   IBM,