Pardesi Vs Desi

Blue --> Westerner
Red --> Asian/Chinese

 

Opinion :

 

Way of Life

Punctuality

 

Contacts

 

Anger

 

Queue when Waiting

 

Me

 

Sundays on the Road

 

Party

 

In the restaurant

 

Stomach Ache

 

Travelling

 

Handling of Problems

 

Three meals a day

 

Transportation

 

Elderly in day to day life

 

Moods and Weather

 

The Boss

 

The child

 

Things that are new

 

Perception of each other

 

Source: Guru

ఖరగోళం వెనుక ఖగోళం, Funny :)

BackStabbing Boss

Back stabbing boss, got shocked after listening these words? don't worry if you are smart worker it wont take much time for you to come to know about this, if you are a hard worker it may take years to understand about this. I am writing this, it doesn't mean that I always worked with such type of people.

Actually the thing is none of the things can controlled by one single person right, we need to work as team to get a fine result, if you are working with a team there will be always pros and cons.

Managers shouldn't play favorites. Those who do inadvertently encourage backstabbing. Those who do and who aren't a good judge of character pretty much ensure it.

And, at the risk of getting a lot of people mad ad me, those who use religion or religiously as a way of determining who is most worthy of their confidences are among the most likely to be poor judges of character. That someone quotes verses of the Bible, the Koran, or the Bhagavat Ghita says nothing at all about how they behave in the workplace.
Now that you know, your choices are simple: Leave your department, leave the company, or wait it out. Leaving the department is probably the best of them.
In a large company it's actually quite likely that those in charge have no idea something like this is going on - they rely on people reporting to people reporting to them to keep this sort of thing under control. The bad news is, it happens. The good news is, it probably isn't happening everywhere. Somewhere in the company you'll find opportunities without having to to change employers.
What's probably the losing strategy is to wait it out. Unless your boss isn't delivering results, that is. You can infer this from knowing, first-hand, that this is how your boss has been managing all along.

Bad bosses -- whether ogres, control freaks, jerks, micro managers, or bumbling fools -- can be found in all organizations. Bad bosses are no laughing matter when you have to face him or her every working day. And, unfortunately, with the rightsizing of the last several years, there are probably more overworked and undertrained bosses than ever. It’s also possible, though, that bad bossing is just part of the organization’s corporate culture.

So, what can you do if you are working for a bad boss? This article will provide you with the tools you need to manage the situation as best you can, but remember that sometimes the only solution is transferring to a different part of the company -- or switching employers.

Make sure you are doing everything right
The first solution is an honest analysis of your actions and behavior. How have you been handling yourself in your job? Have you always taken the high road, or have you resorted to occasional backstabbing, gossiping, or underperforming? If you’re human, it’s likely your bad boss has affected your performance, so try ignoring all these distractions and focus on your work to see if that changes anything. Find other sources of positive reinforcement for doing your job to the best of your abilities.

Compile a list of bad boss behaviors
The second solution is a bit more involved, but should be a cathartic experience for you. Make a list of all the things that your boss does that drive you nuts. Let the list sit for a few days and then review it again, adding or deleting activities upon further reflection. Next, rank the list from most annoying to least annoying. Pick the top two or three worst offenses and develop some suggestions for how your boss could act differently in those situations. Edit the suggestions to remove sarcasm or anger. Show the suggestions to a trusted friend who has no vested interest in the situation. Edit the suggestions again.

Once you feel comfortable that your suggestions are positive and helpful, consider scheduling a meeting with your boss to discuss. Perhaps suggest meeting outside the office for breakfast or lunch. Leave your emotions at the door, but be prepared for your boss to have an emotional reaction. It’s possible that your boss is unaware of his/her actions, and this meeting could be very positive for all involved; however, it’s also possible that the meeting will end badly.

Keep a journal of incidents
The third solution involves documenting each bad behavior of your boss in a journal. Don’t judge or write emotional reactions; simply document the facts of the situation and how the bad behavior impacted your performance -- as well as others in the department. Again, this process may be enough to relieve you of the stress so that you can cope. However, at some point in the future -- perhaps as you are leaving for a new job -- you might consider taking the journal to a trusted colleague in human resources or even a mentor within the company.

Find a mentor with the company
If you love the company but hate the boss, another solution is to develop a mentoring relationship with a boss/supervisor in another part of the company. Mentoring is a fantastic strategy that you should consider even if you have a good boss because a mentor is someone who can help you in many ways, from offering advice to suggesting you for a promotion. And in coping with a bad boss, a mentor can be a good sounding board for you, and perhaps after you have documented all the offenses, someone who has the pull and the power to do something about your bad boss.

Report your bad boss
A last resort is reporting the bad actions/performance of your boss to his/her supervisor -- or to someone in human resources. While logic would hold that the company would not want a manager who is hurting performance or productivity, the reality is often that you become branded as a trouble-maker/whiner/complainer and your days at the company quickly become numbered.

Don’t sacrifice your health or self-esteem
The worst thing you can do is simply to do nothing, hoping the problems will get resolved. No job, boss, or company is worth losing your health, sanity, or self-esteem. If you can’t find a way to resolve these issues and/or your boss simply will never change his/her behavior, you should immediately start working your network and begin looking for a new job -- within or outside the organization. Again, if you love the company, a transfer might be the best option -- but keep in mind that your boss might be as evil as to sabotage that transfer. And try not to quit before you find a new job, but again, if work just becomes too unbearable, you may need to consider quitting to save yourself.

Not All Bosses Are Bad

As much as we like to complain about our bosses, workers respect their bosses a great deal, these are the most important traits for a boss to have:
· Leading by examples
· Strong ethics or morals
· Knowledge of the business
· Fairness
· Overall intelligence and competence
· Recognition of employees

Not sure how many of you have worked with a boss who is having the above features those are real lucky, but not me and very definitely not in my current assignment :).

Mapping Design : Optimization Techniques

---

General Suggestions for Optimizing

1. Reduce the number of transformations. There is always overhead involved in moving data between transformations.
2. Consider more shared memory for large number of transformations. Session shared memory between 12MB and 40MB should suffice.
3. Calculate once, use many times.
   • Avoid calculating or testing the same value over and over.
   • Calculate it once in an expression, and set a True/False flag.
   • Within an expression, use variable ports to calculate a value than can be used multiple times within that transformation.
4. Only connect what is used.
   • Delete unnecessary links between transformations to minimize the amount of data moved, particularly in the Source Qualifier.
   • This is also helpful for maintenance. If a transformation needs to be reconnected, it is best to only have necessary ports set as input and output to reconnect.
   • In lookup transformations, change unused ports to be neither input nor output. This makes the transformations cleaner looking. It also makes the generated SQL override as small as possible, which cuts down on the amount of cache necessary and thereby improves performance.
5. Watch the data types.
   • The engine automatically converts compatible types.
   • Sometimes data conversion is excessive. Data types are automatically converted when types are different between connected ports. Minimize data type changes between transformations by planning data flow prior to developing the mapping.
6. Facilitate reuse.
   • Plan for reusable transformations upfront.
   • Use variables. Use both mapping variables as well as ports that are variables. Variable ports are especially beneficial when they can be used to calculate a complex expression or perform a disconnected lookup call only once instead of multiple times
   • Use mapplets to encapsulate multiple reusable transformations.
   • Use mapplets to leverage the work of critical developers and minimize mistakes when performing similar functions.
7. Only manipulate data that needs to be moved and transformed.
   • Reduce the number of non-essential records that are passed through the entire mapping.
   • Use active transformations that reduce the number of records as early in the mapping as possible (i.e., placing filters, aggregators as close to source as possible).
   • Select appropriate driving/master table while using joins. The table with the lesser number of rows should be the driving/master table for a faster join.
8. Utilize single-pass reads.
   • Redesign mappings to utilize one Source Qualifier to populate multiple targets. This way the server reads this source only once. If you have different Source Qualifiers for the same source (e.g., one for delete and one for update/insert), the server reads the source for each Source Qualifier.
   • Remove or reduce field-level stored procedures.
   • If you use field-level stored procedures, the PowerCenter server has to make a call to that stored procedure for every row, slowing performance.

Lookup Transformation Optimizing Tips

1. When your source is large, cache lookup table columns for those lookup tables of 500,000 rows or less. This typically improves performance by 10 to 20 percent.
2. The rule of thumb is not to cache any table over 500,000 rows. This is only true if the standard row byte count is 1,024 or less. If the row byte count is more than 1,024, then the 500k rows will have to be adjusted down as the number of bytes increase (i.e., a 2,048 byte row can drop the cache row count to between 250K and 300K, so the lookup table should not be cached in this case). This is just a general rule though. Try running the session with a large lookup cached and not cached. Caching is often still faster on very large lookup tables.
3. When using a Lookup Table Transformation, improve lookup performance by placing all conditions that use the equality operator = first in the list of conditions under the condition tab.
4. Cache only lookup tables if the number of lookup calls is more than 10 to 20 percent of the lookup table rows. For fewer number of lookup calls, do not cache if the number of lookup table rows is large. For small lookup tables(i.e., less than 5,000 rows), cache for more than 5 to 10 lookup calls.
5. Replace lookup with decode or IIF (for small sets of values).
6. If caching lookups and performance is poor, consider replacing with an unconnected, uncached lookup.
7. For overly large lookup tables, use dynamic caching along with a persistent cache. Cache the entire table to a persistent file on the first run, enable the update else insert option on the dynamic cache and the engine will never have to go back to the database to read data from this table. You can also partition this persistent cache at run time for further performance gains.
8. Review complex expressions.

• Examine mappings via Repository Reporting and Dependency Reporting within the mapping.
• Minimize aggregate function calls.
• Replace Aggregate Transformation object with an Expression Transformation object and an Update Strategy Transformation for certain types of Aggregations.

Operations and Expression Optimizing Tips

1. Numeric operations are faster than string operations.
2. Optimize char-varchar comparisons (i.e., trim spaces before comparing).
3. Operators are faster than functions (i.e., vs. CONCAT).
4. Optimize IIF expressions.
5. Avoid date comparisons in lookup; replace with string.
6. Test expression timing by replacing with constant.
7. Use flat files.

• Using flat files located on the server machine loads faster than a database located in the server machine.
• Fixed-width files are faster to load than delimited files because delimited files require extra parsing.
• If processing intricate transformations, consider loading first to a source flat file into a relational database, which allows the PowerCenter mappings to access the data in an optimized fashion by using filters and custom SQL Selects where appropriate.

1. If working with data that is not able to return sorted data (e.g., Web Logs), consider using the Sorter Advanced External Procedure.
2. Use a Router Transformation to separate data flows instead of multiple Filter Transformations.
3. Use a Sorter Transformation or hash-auto keys partitioning before an Aggregator Transformation to optimize the aggregate. With a Sorter Transformation, the Sorted Ports option can be used, even if the original source cannot be ordered.
4. Use a Normalizer Transformation to pivot rows rather than multiple instances of the same target.
5. Rejected rows from an update strategy are logged to the bad file. Consider filtering before the update strategy if retaining these rows is not critical because logging causes extra overhead on the engine. Choose the option in the update strategy to discard rejected rows.
6. When using a Joiner Transformation, be sure to make the source with the smallest amount of data the Master source.
7. If an update override is necessary in a load, consider using a Lookup transformation just in front of the target to retrieve the primary key. The primary key update will be much faster than the non-indexed lookup override.

Suggestions for Using Mapplets

A mapplet is a reusable object that represents a set of transformations. It allows you to reuse transformation logic and can contain as many transformations as necessary. Use the Mapplet Designer to create mapplets.

1. Create a mapplet when you want to use a standardized set of transformation logic in several mappings. For example, if you have several fact tables that require a series of dimension keys, you can create a mapplet containing a series of Lookup transformations to find each dimension key. You can then use the mapplet in each fact table mapping, rather than recreate the same lookup logic in each mapping.
2. To create a mapplet, add, connect, and configure transformations to complete the desired transformation logic. After you save a mapplet, you can use it in a mapping to represent the transformations within the mapplet. When you use a mapplet in a mapping, you use an instance of the mapplet. All uses of a mapplet are tied to the parent mapplet. Hence, all changes made to the parent mapplet logic are inherited by every child instance of the mapplet. When the server runs a session using a mapplet, it expands the mapplet. The server then runs the session as it would any other session, passing data through each transformation in the mapplet as designed.
3. A mapplet can be active or passive depending on the transformations in the mapplet. Active mapplets contain at least one active transformation. Passive mapplets only contain passive transformations. Being aware of this property when using mapplets can save time when debugging invalid mappings.
4. Unsupported transformations that should not be used in a mapplet include: COBOL source definitions, normalizer, non-reusable sequence generator, pre- or post-session stored procedures, target definitions, and PowerMart 3.5-style lookup functions.
5. Do not reuse mapplets if you only need one or two transformations of the mapplet while all other calculated ports and transformations are obsolete.
6. Source data for a mapplet can originate from one of two places:

• Sources within the mapplet. Use one or more source definitions connected to a Source Qualifier or ERP Source Qualifier transformation. When you use the mapplet in a mapping, the mapplet provides source data for the mapping and is the first object in the mapping data flow.
• Sources outside the mapplet. Use a mapplet Input transformation to define input ports. When you use the mapplet in a mapping, data passes through the mapplet as part of the mapping data flow.

1. To pass data out of a mapplet, create mapplet output ports. Each port in an Output transformation connected to another transformation in the mapplet becomes a mapplet output port.

• Active mapplets with more than one Output transformations. You need one target in the mapping for each Output transformation in the mapplet. You cannot use only one data flow of the mapplet in a mapping.
• Passive mapplets with more than one Output transformations. Reduce to one Output Transformation; otherwise you need one target in the mapping for each Output transformation in the mapplet. This means you cannot use only one data flow of the mapplet in a mapping.

Source: Informatica

Informatica Upgradation to 8.1.1

This document will prepare you for the things you should look for when planning your upgrade so that your upgrade process will go as smoothly as possible.

IMPORTANT NOTES:

• This document is for issues that will arise when upgrading from PowerCenter 7.1.x only. If you are upgrading from versions prior to 7.1.x, refer to the "Global Customer Support PowerCenter 7.1 Upgrade guide".

• If you have repositories that are a version prior to 6.0 they cannot be upgraded directly to PowerCenter 8.1.1 SP4. In such cases they must first be upgraded to 6.x or 7.x version and then upgraded to 8.1.1 SP4.

• For further information on upgrading to PowerCenter 8.1.1 SP4 and a complete list of upgrade changes refer to the PowerCenter 8.1 Upgrade Guide.

• For a complete list of all known issues and limitations and other upgrade information refer to the PowerCenter 8.1.1 SP4 Release Notes.

---

1. Upgrade

1.1. Cannot upgrade a repository with special characters in name

The repository service name (which is the same as the repository name) cannot have the following special characters in its name: ?, ", <, >, *, /, , tab and trailing spaces. In previous versions of PowerCenter all these characters were allowed in the repository name. In order to upgrade these repositories, restore the repository with a different name in the older version and then upgrade using 8.1.

1.2. Teradata and Informix repositories no longer supported

You will not be able to upgrade a Teradata or Informix repository using PowerCenter 8.1.
To upgrade a PowerCenter 7.x repository in a Teradata or Informix database, copy the repository to a database supported by PowerCenter 8.1 (Oracle, DB2, Microsoft SQL Server or Sybase) using PowerCenter 7.x. Then upgrade this repository to PowerCenter 8.1.

1.3. Server Grid

Server Grids existing in PowerCenter 7.x will not be upgraded in PowerCenter 8.1. Create a new grid object in the PowerCenter 8.1 Administration Console. Refer to the PowerCenter Upgrade Guide.

1.4. Do not create a new Integration Service for already existing servers in upgraded repositories.

Do not create a new Integration Service for already existing servers in upgraded repositories. If you create a new service in the Administration Console in an upgraded repository with the same name as a server in that same repository there will be two servers of the same name in the Workflow Manager and sessions will be assigned to the original server.
Use the PowerCenter server configuration file in the Upgrade tab in the Administration Console.

1.5. Repository Service cannot create or upgrade repository on Oracle 10

The Repository Service cannot create or upgrade a repository on Oracle when the Oracle server version is 10.1.0.2 or 10.1.0.3 and is on a different platform than the Oracle client.
The Repository Service writes the following message to the service log:

ERROR: OBJM_54543 [Tue Nov 09 19:42:35 2004] : (23201972) DataBase error: ORA-01455: converting column overflows integer datatype

Workaround: Perform one of the following actions:

• Use the same platform for the Oracle server and client.
• Upgrade Oracle server to version 10.1.0.4.
• Contact Oracle about bug 3417593 to install a patch for the Oracle server.

1.6. Using ODBC Database Connectivity on UNIX

PowerCenter 8.1 does not package DataDirect ODBC drivers for Oracle, IBM DB2, or Sybase ASE on a UNIX machine.
If you use DataDirect ODBC drivers packaged by PowerCenter to connect to Oracle, IBM DB2, or Sybase ASE from a UNIX machine, install database client software and configure native connectivity on the machine that runs the Integration Service. You can also use a third-party ODBC driver that is level 2 or above compliant.
For more details refer to the PowerCenter Post-Upgrade Reference Guide.

---

2. Services

2.1. When a server variable is changed the Data Integration Service must be re-started.

In previous versions server variables ($PMRootDir, $PMWorkflowLogDir, $PMCacheDir, etc.) could be changed and the server did not need to be re-started. Now in PowerCenter 8.1 it is necessary to re-start the the Integration Service after modifying these variables.

2.2. MaxSessions is replaced by MaxProcesses

The PowerCenter Server parameter MaxSessions has been replaced with the Integration Service parameter MaxProcesses. Now in PowerCenter 8.1 this value includes stand alone Command tasks. Depending on the number of stand alone Command tasks used a fewer number of Session tasks may be able to run concurrently in PowerCenter 8.1 than in previous versions.

2.3. Low precision decimal values are rounded.

Previously in 7.x, whenever we had a decimal in low precision that was originally a double, we guaranteed only the first 15 digits would be correct. The remaining digits would be whatever the OS returned to us.
Now in PowerCenter 8.1 this behavior has been corrected, the value is rounded and the remaining digits are now zeroed out.
Example:

7.x
8.1

123456580.901844999999980
123456580.90184500000000

2.4. ZoneAlarm firewall prevents you from logging in to the Administration Console

If the network is protected by a ZoneAlarm firewall that blocks third-party cookies, you may not be able to log in to the PowerCenter Administration Console.

Workaround: Disable the blocking of third-party cookies.

2.5. Command task error messages do not appear in the workflow log

The Integration Service writes error messages generated by the Command task to the Log Service as part of the domain log events. It does not write them to the workflow log.

Workaround: To view Command task error messages, view domain log events in the Log Viewer.

2.6. Repository Service processes in different domains can connect to the same repository database

The Administration Console does not prevent you from associating Repository Services in different PowerCenter domains with the same repository database. When two Repository Services access the same repository database, you may experience repository inconsistencies and object locking issues.

Workaround: If the PowerCenter environment includes multiple PowerCenter domains, ensure that a one-to-one relationship exists between Repository Services and repository databases across all domains. If two Repository Services are associated with the same repository database, disable all Repository Service processes for one of the Repository Services. Then, uniquely associate that Repository Service with a different repository database, or remove that Repository Service.

2.7. You cannot concurrently update service options and service process options for a single service

If you use the Administration Console or infacmd command line program to update options for the same service at the same time, only the last option saved is updated.

Workaround: Allow one command to complete before entering the next command.

2.8. Session fails after upgrade due to invalid lookup SQL override

Even though an SQL override is valid and works correctly in PowerCenter 7.1.1 or earlier, it fails in later releases in some instances, including the following cases:

• It includes comments placed between /* */.
• It contains a subquery.
• It uses a Trim (BOTH FROM) command.

Workaround: For a simple SQL override, rewrite the SQL statement.
-or-
For other SQL overrides, configure the following custom property in the Administration Console for the Integration Service:

lookupOverrideParsingSetting=1

2.9. Cannot edit Web Services Hub properties on the Administration Console after upgrade from PowerCenter 8.1

After you upgrade to PowerCenter 8.1.1 SP3, the Web Services Hub does not have the following properties set:

• SessionExpiryPeriod
• MaxLMConnections

You cannot change these Web Services Hub properties in the Administration Console.
Workaround: Create Web Services Hub and configure the properties on the Administration Console. Alternatively, you can use the command line program infacmd to change the settings of the Web Services Hub properties. Use the -so option with the UpdateWSHubService command to configure the properties.

2.10. Cannot change Repository Service properties after upgrade

If a Repository Service does not have all the required properties after you upgrade to PowerCenter 8.1.1 (SP3), you cannot change the Repository Service properties in the Administration Console. For example, if a Repository Service does not have the DBPoolExpiryThreshold and DBPoolExpiryTimeout properties in PowerCenter 8.1.1 (SP3), you cannot use the Administration Console to modify the Repository Service properties, such as the operating mode.
Workaround: Use the infacmd UpdateRepositoryService command to add the missing properties to the Repository Service. For example, if the Repository Service lacks the DBPoolExpiryThreshold and DBPoolExpiryTimeout properties, use the -so option with the UpdateRepositoryService command to add the missing properties and their values. Then, you can use the Administration Console to modify the Repository Service properties. Alternatively, create a Repository Service that has all the required properties.

2.11. Nodes upgraded from PowerCenter 8.1 have different default values for some Load Balancer settings

If you created nodes using PowerCenter 8.1, and you upgrade from version 8.1 to version 8.1.1 (SP3), the upgraded nodes have the following default values for the “CPU Profile” and “Maximum Memory %” general properties:

• CPU Profile = 10 (should be 1.0)
• Maximum Memory % = 100% (should be 150%)

Workaround: If you use metric-based or adaptive dispatch mode, manually set “Maximum Memory %” to 150% or some other value. If you use adaptive dispatch mode, calculate the CPU profile for all nodes in the grid, or manually set the CPU profile for the upgraded nodes to 1.0.

2.12. Cache memory and DTM may not be optimized on session in upgraded repository.

Sessions in upgraded repositories have preset values for automatic memory settings that may not be optimal. For more details refer to KnowledgeBase article 20919.

2.13. Flat file target header column names can be specified at the session level now.

Starting with PowerCenter 8.1 a flat file target can be configured to include column names as the first row. For more details refer to KnowledgeBase article 13533.

2.14. Session on grid can run on backup node

A session can run on a backup node when it is configured to run on a grid. For more details refer to KnowledgeBase article 20000.

2.15. Certain repository operations must be done in "Exclusive mode"

The PowerCenter repository must first be set to Exclusive Mode before performing certain repository operations, such as backup and delete. For more details refer to KnowledgeBase article 18156.

2.16. Sessions fail while upgrading the incremental aggregation cache

When you use an incremental Aggregator cache file from a previous PowerCenter version in a session, the session fails while upgrading the cache to the current version.
Workaround: Rebuild the cache.

2.17. Sessions may fail with upgraded Advanced External Procedure transformations

Sessions with Custom transformations that were upgraded from Advanced External Procedure transformations fail if you used the following upgrade path:
1. You created the transformation in version 4.x and upgraded to version 7.0 or 7.1.
2. You upgrade the 7.0 or 7.1 repository to version 8.x.
These Custom transformations have an IsActive attribute set to false. The IsActive attribute should be true.
Workaround: Export the Custom transformation to an XML file. Change the IsActive attribute to true in the XML file and import the object from the XML file.

---

3. Command Line

3.1. The PmRepAgent command has been removed

The pmrepagent command no longer exists in PowerCenter 8.1 and now all repository commands have been consolidated into the pmrep command.
The following commands are now performed using the pmrep command line tool:

• Connect
• Showconnectioninfo
• Deployfolder
• Deploydeploymentgroup
• Register
• Unregister
• Notify

For these commands to work the Repository Service must be running.
To restore a repository using pmrep: the user first has to create a repository service and enable it. This will start a PmRepAgent process even though the repository database has not been created yet.
Refer to the PowerCenter Upgrade Guide for more information.

3.2. Some Commands have been moved from pmrep to infasetup or infacmd.

The following commands are no longer performed using pmrep. They will be available in either the infasetup command line tool or infacmd.

• Updatesrvvar
• Updateserver
• Deleteserver
• Addserver
• Addrepository
• Removerepository
• Stoprepository
• Enablerepository
• Disablerepository

3.3. New connection options for pmcmd

In the previous version pmcmd could work by specifying the host name/port number of any of the Servers in a Server Grid. This is no longer supported. If the Integration Service has more than one node in it, use the new –service -sv option instead.

3.4. New Load Manager behavior for pmcmd

In previous versions all worker Load Managers were accepting connections from the client applications. Now, in PowerCenter 8.1, when pmcmd connects to a worker Load Manager, it will redirect the connection to the master Load Manager by default. Two properties are available to change the behavior – WorkerAcceptsAllConnection and EnableConnectionRedirection. Refer to KnowledgeBase Article 15951 for more details.

3.5. The infasetup DefineDomain command does not support Windows authentication for SQL Server domain configuration databases

The infasetup DefineDomain command does not support the Microsoft SQL Server feature that allows you to log in to the database using your Windows user name and password. To define a domain that uses a Microsoft SQL Server domain configuration database, you must enter a valid database user name and password.

3.6. infasetup displays an error message if you omit the -databasepassword (-dp) option

If you omit the -databasepassword (-dp) option from an infasetup command that expects this option as a mandatory one, infasetup displays an error message. This prevents infasetup from obtaining the password from the INFA_DEFAULT_DATABASE_PASSWORD environment variable.

Workaround: Specify the domain configuration database password using the -dp option.

---

4. Client

4.1. Explicit Checkout

In previous versions of PowerCenter repository objects were implicitly checked-out (automatically checked-out when the object is edited). Now users have to explicitly check-out the objects and and there is no option to revert to the implicit check-out behavior.
When a repository user first opens an object it will be read-only and will require the user to check it out before it can be edited.

4.2. ALL: Creating or restoring a repository no longer adds the repository to the client tools Repository Navigator automatically.

After creating or restoring a repository in PowerCenter 8.1, you must Add the repository to the client tools.

4.3. ALL: Client needs Write Access to the client install directory

In previous versions, all client repository information was stored in the Windows Registry. In PowerCenter 8.1, while some information is still stored in the registry, the client now stores (and writes to) a file on disk called domains.infa. The client will store the domain_name/hostname/portnumber in this file. As a result, the client MUST have write-access to this file.

---

5. Expressions

5.1. DATE_DIFF function correctly calculates the difference in dates that include leap years. If you use the DATE_DIFF function to calculate the number of months or years between two dates, where one date is a leap year, the DATE_DIFF function returns a more accurate value for the number of months or years.

In previous releases, the DATE_DIFF function returned inaccurate values if one of the dates included a leap year. If you modified any expression to correct the error in months or years, you may want to update the expression. For more details refer to the PowerCenter Post-Upgrade Reference Guide.

5.2. Integration Service fails to match a lookup value using ROUND(TO_DECIMAL(string)) in a string lookup port expression in low precision mode

The upgrade process from versions prior to 6.1 replaces TO_INTEGER() with ROUND(TO_DECIMAL()). When you have ROUND(TO_DECIMAL()) in a lookup port with a String datatype, the Integration Service does not match the port value with a string integer value in the lookup cache or table in low precision mode.
For example, you have the following expression in a previous version of PowerCenter or PowerMart:

TO_INTEGER(‘5.18’)

The upgrade process changes this expression to:

ROUND(TO_DECIMAL(‘5.18’))

ROUND(TO_DECIMAL()) returns values as a Double with trailing zeros in low precision mode.
Workaround: Manually change expressions in string lookup ports of a Lookup transformation. Change ROUND(TO_DECIMAL()) to TO_INTEGER().

5.3. Change of ROUND function behavior

The behavior of the ROUND function has been reverted to PowerCenter 7.x.
If you are upgrading from 7.x then there will be no change in the behavior of expressions using the ROUND function.
If you are installing SP4 on top of PowerCenter 8.1.x versions ROUND behavior will change.
Example:
Round of zero (ROUND(0,2)) will return 0.00 and not 0.01.

Source: Informatica

What not to say during a job interview - Forbes.com

The pressure of an interview just gets to some people. The next thing you know, they're bringing their mothers in to answer the questions of a prospective employer. Or they're breaking into song about why they should be hired.

It's ridiculous. It's nervy. And unlike the urban legends of the candidates who supposedly conducted their entire interviews using a sock puppet or ventriloquist's dummy, these actually happened.

In a national poll conducted by the staffing and consulting firms RHI and Accountemps, 150 senior executives, including those from human resources, finance and marketing departments, were asked, "What is the wackiest or most unusual pitch you've heard from a job seeker about why he or she should get the job?"

You might not believe the answers, unless you're the one who has said you wanted the job because you're trying to get away from people.

Dawn Fay, manager of professional staffing services at RHI, agreed that even a creative team of researchers would be hard-pressed to make up such absurd answers as, "I'm allergic to unemployment."

"Some of the responses we find to this question are said because people are nervous," Fay said. However, she questioned if anxiety could prompt anyone to deliver his resume in a brown paper lunch bag, which again, has happened.

"Other people think it's good to weave in humor."

That's not to say one shouldn't temper the seriousness of a conversation with a joke or two if it's fitting. Just don't overdo it by drafting your own press release welcoming yourself as the newest member of the company.

Being that the main goal of any staffing agency is to help people find work, the survey offers hints on interview preparation — in particular, how to answer the staple question, "Why should I hire you?"

Apparently, plenty of job seekers are still in need of this advice.

"A lot of people will stress out before an interview," Fay said. "This is the one question you should be prepared to answer."

According to Accountemps, a job candidate should "look on the bright side," meaning don't view any question as an obstacle. Remember, you're on an interview to talk about how you can become an asset to the company. Also, Accountemps says, make sure you tailor your response appropriately, always show enthusiasm and above all else, "prepare, prepare, prepare."

IT in India: Big successes, bigger gaps Jairam Ramesh in New Delhi | October 01, 2007 08:43 IST

The IT industry has grown spectacularly in the past decade -- at least the export segment. The industry is at that critical inflection point where its multiplicative impact will start becoming visible and tangible. Going by current trends, IT will have the same impact in the next three to four years as it has had in the past 20 years.

A couple of months back, the securities firm CLSA came out with a detailed analysis of the Indian IT industry. The analysis revealed:

• 20-25 per cent of India's GDP expansion over the next three to four years will come from IT;
• India's IT exports will cross the country's oil imports from 2007-08 onwards assuming that oil prices are at around $65 a barrel;
• The IT industry -- directly and indirectly -- will pick up a third of the addition to the urban labour force over the next three to four years.

What's bothersome is the slow geographical spread of IT. Let us take IT exports as a whole, which in 2006-07 were around $32 billion or around Rs 144, 214 crore (Rs 1,442.14 billion). This is how it was spread across locations of the software technology parks.

Seven cities accounted for a whopping 95 per cent -- Bangalore (33 per cent), the National Capital Region (15 per cent), Chennai (14 per cent), Hyderabad (13 per cent), Pune (10 per cent), Navi Mumbai (8 per cent) and Kolkata (2 per cent).

• Seven cities together account for yet another 3 per cent -- in descending order of contribution these are Mysore, Bhubaneswar, Mangalore/Manipal, Gandhinagar, Thiruvananthapuram, Mohali and Jaipur.
• Four cities together account for yet another 0.6 per cent: Indore, Vishakapatnam, Kochi and Coimbatore in descending order of contribution.

There are valid reasons for this geographic distribution. The IITs of Kanpur and Kharagpur are almost non-existent on the IT map of India, proving that the IITs have had great global impact but their local impacts have not been commensurate with the hype that has come to surround them. Furthermore, SEZs appear to be increasing the digital divide. I have always felt that the true value of SEZs must be judged by the extent to which they help promote labour-intensive manufacturing. But so far, of the 142 SEZs notified, 86 are for IT and ITES alone. And of these 86, the usual suspects are most prominent -- 26 are in Andhra Pradesh, 14 in Tamil Nadu, 13 in Karnataka and 10 in Maharashtra, making a total of 80 per cent in these four states alone.

The need now is to think of the under-served regions and areas. Sure, infrastructure and connectivity will have to improve but some entrepreneurial endeavour will not be out of place. TCS [Get Quote] is working to develop Guwahati as an IT location using the IIT there as a focal point. Nasscom needs to engage with state governments that are now not on the IT radar screen and work with them to develop promising locations.

How long can the IT industry be in the "To HiB or not to be HiB" mindset? Seventy-five per cent of our software industry is exports, unlike China, where the domestic market consumes 75 per cent of the business. We have had the computerisation of land records in a couple of states like Karnataka and, of course, the computerisation of railway reservations, which has had tremendous social value as well. We need to take up a couple of national initiatives in a PPP mode where IT can bring about a transformation.

In addition to the initiatives taken by different state governments, the Central government has recently launched a very major e-governance programme. Twenty-seven mission-mode projects have been taken up in addition to the establishment of infrastructure. Of these nine are in the Central government and cover income tax, passport and immigration, company affairs, insurance, citizen data base, excise, pensions, banking and public grievances. Eleven projects are with state governments and cover areas like land records, road transport, property registration, treasuries, panchayats and municipalities, commercial taxes, police and employment exchanges. Seven projects are in the integrated services category and cover areas like EDI for international trade, e-procurement, e-commerce, e-businesses and common service centres. By December 2008, the state-wide area network project at a cost of over Rs 3,000 crore (Rs 30 billion) is expected to be in place with a minimum 2 Mbps connectivity till block level and around 7,000 points of presence all over the country.

Competitiveness, we have been led to believe, emanates from technology development. This is true to an extent. My own view has always been that it is technology application that in the long run leads to productivity gains. We have not paid adequate attention to this aspect of technology strategy and all that it entails. Technology is always embedded in a social context and unless we focus on the core, unless we always keep in mind the adage -- technology is the answer but what was the question -- we are liable to be disillusioned soon.

My fourth and final point relates to the use of IT as an instrument of the country's strategic and economic diplomacy, something in which I have got involved of late. It is well-known that the development of our IT capability has had a profound impact on Indo-US relations. As the author of Chindia I have absolutely no doubt that Chinese attitudes towards us underwent a fundamental shift when our IT export industry emerged in the USA in such a stunning manner. 

It was the late Dewang Mehta who did so much to build the Nasscom brand who once said that India was doing very well in IT and beauty because government was far away from both. He was not entirely right about the former. The government has indeed played a key role in creating infrastructure and I am of the firm opinion that cities like Bangalore and Hyderabad could not have achieved their current status without the crucial investments made in public S&T there from the late 1950s onwards. Public investments can still play a catalytic role, even in these days of PPP.In IT, there is great scope for true PPP as for example in the area of education and training. I do hope that while exulting in its global success, every once in a while Nasscom reminds itself of its local roots and its domestic imperatives.

The author is Union minister of state for commerce. This piece has been excerpted from his address to the Nasscom executive board on September 19

leader

This is the perfect definition for leader ship :

The art of getting someone else to do something you want done because he wants to do it.

Some qualities Leader should have :

Leader is a servant : Authority does not exist for its own sake, but for the sake of those under that authority. Leaders exist to meet the needs of those they lead.

Leader is loyal : A leader should foster loyalty at every level, not just from the people to the leader, but from the leader to the people.

Leader has dirty hands : A leader will get his hands in the work, not to Lord it over the people, but to understand what must be done.

Leader will embrace dissent : Since a leader knows his limitations, he will listen to those who disagree with him. Dissent between brothers can be healthy.

Leader builds leaders not followers : A leader should lead people to grow and mature, from zero to hero , instead of leaving them babes.

Leader should create a path : Leader should not follow where the path may lead, go instead where there is no path and leave a trail.

Leader should be the part of the team : Go to the people. Learn from them. Live with them. Start with what they know. Build with what they have. The best of leaders when the job is done, when the task is accomplished, the people will say we have done it ourselves.

to be contd......

my inspiration for blogging

I've to mention it here, I've seen lot of blogs but never thought to start of my own, but couple of new friends and my old buddy "CSMK" inspired me to start this blogging, which is a good thing (too much is always bad) so I want to be in the good part.

my life so far.....

 

Chittoor : The place where  I was born and brought up.

Bangalore : The Place where I started my career.

America : The Place where I've seen the real commercial human life.

 

Life in Chittoor : It was pretty cool in all the terms "BINDAAS" no body to question no need to answer any body (of course parents are always there to ask and listen).

Life in Bangalore :

First visit to Bangalore (in 1998-99) :I've reached bangalore first time when I am doing my graduation this time for roaming around "बाप का खून कि कमाइ को उडाने के लिये" so had fun had and a pretty good time.

Second visit (in 2002-03) : This is when I started to fight the battle of life (struggle for job), this time bangalore was horrible not at all good ("typical human thinking", when everything is going good everything and everybody is good, something goes wrong everything and everybody is wrong)

By god's grace or my parents blessings or because of good friends I've I got a break pretty soon but still fight was on, but this time fight is for survival (in job) during this period bangalore is ok, then again some struggle then got a big break during 2004 now the fight is more interesting (earlier fight was between our kind of people) now "Welcome to Corporate WORLD" "घन्दा है पर दन्दा है ये" so initial stages struggled bit to settle down(because of some very good friends in the same corporate world), then forget about whole world just office, home that's it for two long years (after seeing back even though I've gained a little but I've lost a lot, which never comes back "कुच पाने के लिये कुच खोना पड्ता है, मगर हम तो मज्बूरन कुच पाने के लिये बहुत कोदिया", but here this "कुच"  made lot of diff dude ;),  hopefully I'll get back some at least)

Life in USA :

Now the life moved ahead a bit to USA (Dollar dreams), which came true for me with out much dreams (luckily or unluckily)

On 2006 Welcome to USA (Welcome to Commercial World on the Earth I've ever seen so far) From May'06 to Aug'06 was the one of the most horrible days of my life time (which I never want to forget) which has shown my life a new path.

Now the life is ok (cannot be best until unless you feel like that), I've met lot of new people with different attitudes (I can say I've seen the world), but pure commercial (As far as I've seen we can get only 1 % of real friendship, luckily I got, I guess).

Still struggle is going on..... which never ends....... ends only @ final destination :)

perfect definition for UNITY

Pefect Defintion for Unity.

Facts…

ఆకొన్న కూడె అమృతము తాకొంకక నిచ్చువాడె ధాతధరిత్రి సోకూర్చు వాడె
మనుజుడు తేకువ కలవాడె వంశతిలకుడు సుమతి

ఎప్పుడు దప్పులు వెదుకుడు నప్పురుషుని గొల్వగూడ దది యెట్లన్నన్సర్పంబు
పడగ నీడన గప్ప వసించిన విధంబు గదరా సుమతి

ఎప్పుడు సంపద కలిగిన నప్పుడె బంధువులు వత్తురది యెట్లనిన్నన్దెప్పలుగ
జెరువు నిండిన గప్పలు పదివేలు చేరుగదరా సుమతి

about life

Life :

You are the architect of your own Life .

Life is not easy to live, but too hard to leave.

The best way to prepare for life is to begin to live.

Unrest of spirit is a mark of life; one problem after another presents itself and in the solving of them we can find our greatest pleasure

As U grow to understand life less and less,
U learn to love it more and more.

The whole of life is but a moment of time. It is our duty, therefore to use it, not to misuse it.

You can make your life as an inspiration to others or inspired by others.

After the game, the king and the pawn go into the same box.

Live your life as you give life to others, not for others.