What is the difference between a fly and a mosquito???
........socho socho..........
its simple......................................
A fly can fly but a mosquito cannot mosquito !!!
Tuesday, January 19, 2010
Ramesh Waiter Ki kahani
Ramesh, ek berozgar aur aalsi aadmi aadmi tha.. College ke baad usey kahi bhi koi job nahi milta. Wo thak haarkar ek hotel mai Waiter ka kaam karna shuru kar deta hai...Par aalsi hone ki vajah se wo kabhi koi order sahi nahi leta..Agar customer order dene ki koshish karta, to wo kalti maar deta aur order note nahi karta...Uske kalti maarne ki aadat ke kaaran Hotel ke Maalik ne usey naukri se nikaal diya aur kaha, " Ramesh, tum Achche waiter to na ban sake, par achche kisaan zaroor banoge"Aakhir Hotel ke Maalik ne aisa kyu kaha??????
Kyu kyu kyu???!!!!!!!!
Socho!!!!!!!!!!!!!
Because......!!!!!!!!!!!!!!!!Ramesh ek Kalti-Waiter tha (Cultivator)
IIF Expressions in Informatica Power Center
Nested IF Expressions can be complex to write in Informatica using IIF. A simpler way to write nested IF is to use the decode function.
For example, if you need to write something like
IF ( A > B ) THEN 1
ELSE IF ( C > D ) THEN 2
ELSE IF ( E > F ) THEN 3
ELSE 4
can be written as
DECODE(TRUE,A>B,1,
C>D,2,
E>F,3,
4)
Is that helpful???
Informatica Tips
Tip 1:
Always use sorted data for very large data aggregations, or use PowerCenter server 64-bit , and allocate a large amount of memory. Sorted aggregations run much faster than unsorted aggregations.
Tip 2:
Aggregator transformations do not sort data. The aggregator uses a clustering algorithm, not a sort algorithm. When there are duplicate rows the aggregator may put data out in a seemingly sorted order but it does not guarantee it.
Tip 3:
Keep mappings as simple as possible. The smaller the better in terms of performance and tuning. Divide and conquer is the best strategy for fastest mapping performance. Sometimes multi-staging the work, or splitting the workload between the database and stages can release dependencies upstream, and increase parallelism.
Tip 4:
Make sure to allocate a large amount of memory (as much as possible) for mapping objects that cache.
Tip 5:
Aggregator transformations can be used to pivot (de-normalize) data.
Tip 6:
When replacing PERL code, make sure to break the code into units of work. Use each unit as a design step in the mapping architecture. Develop the overall complex mapping, then break it apart into smaller manageable steps.
Tip 7:
Keep the mapping objects as streamlined as possible. Run the data through the transforms, not around them. This helps with the partitioning options at the session level, as well as the parallelism capabilities of the mapping.
Tip 8:
When using a Sort, Aggregator, Joiner, or Lookup transformation keep the keys as "small" as possible (measured in precision). Much of the same mathematics that play in computing relational database indexes also play in computing the"indexed" fields that perform the operations listed above.
Tip 9:
Keep filter conditions simple, move the complex condition expressions into expression objects. This keeps the filter fast. When the filter runs slowly it's usually because of a complex condition.
Tip 10:
Break complex conditions down into smaller parts. Use the variables within an expression to build complex expression logic. This keeps the mappings more maintainable.
Tip 11:
Never have more than five (5) targets per mapping. This will slow down the mapping exponentially. Complex maps usually demand multiple targets, but the more targets you have, the poorer the performance.
Tip 12:
Complex architectures usually require update strategies within the mapping. The update strategies can result in a performance hit to the session, sometimes significant. It is recommended to minimize the usage of Update Strategies transformations for optimal performance.
Tip 13:
If you have very large and complex mappings that are running with a large amount of data (~50 million+ rows) then it is recommended to use the PowerCenter 64-bit server for optimal performance. It provides you with access to plenty of memory and high speed performance for large mappings.
Tip 14:
Any mapping with 50+ objects is simply too large and MUST be broken down into multiple mappings.
Tip 15:
To create complex output (say a mainframe ASCII file), use a single flat file, single string (4k if necessary), format the string in one or more export "expressions". Use the LPAD and RPAD functions to re-format data, and put record indicator columns on the output side.
Tip 16:
Always set the "master" in the joiner to be the smaller of the two tables (except when using detail outer join or full outer join). This will keep the caching of the two set to the minimum number of rows.
Tip 17:
Replace a lookup with a joiner, whenever you are faced with extremely large data sets
Tip 18:
Use reusable lookups instead of the same lookup multiple times. This will assist in reusing the lookup caches, and improve performance.
Tip 19:
If you are going to use a sequence generator, and share it across multiple mappings (or make the session run in parallel) then set it to cache a minimum of 10,000 values.
Always use sorted data for very large data aggregations, or use PowerCenter server 64-bit , and allocate a large amount of memory. Sorted aggregations run much faster than unsorted aggregations.
Tip 2:
Aggregator transformations do not sort data. The aggregator uses a clustering algorithm, not a sort algorithm. When there are duplicate rows the aggregator may put data out in a seemingly sorted order but it does not guarantee it.
Tip 3:
Keep mappings as simple as possible. The smaller the better in terms of performance and tuning. Divide and conquer is the best strategy for fastest mapping performance. Sometimes multi-staging the work, or splitting the workload between the database and stages can release dependencies upstream, and increase parallelism.
Tip 4:
Make sure to allocate a large amount of memory (as much as possible) for mapping objects that cache.
Tip 5:
Aggregator transformations can be used to pivot (de-normalize) data.
Tip 6:
When replacing PERL code, make sure to break the code into units of work. Use each unit as a design step in the mapping architecture. Develop the overall complex mapping, then break it apart into smaller manageable steps.
Tip 7:
Keep the mapping objects as streamlined as possible. Run the data through the transforms, not around them. This helps with the partitioning options at the session level, as well as the parallelism capabilities of the mapping.
Tip 8:
When using a Sort, Aggregator, Joiner, or Lookup transformation keep the keys as "small" as possible (measured in precision). Much of the same mathematics that play in computing relational database indexes also play in computing the"indexed" fields that perform the operations listed above.
Tip 9:
Keep filter conditions simple, move the complex condition expressions into expression objects. This keeps the filter fast. When the filter runs slowly it's usually because of a complex condition.
Tip 10:
Break complex conditions down into smaller parts. Use the variables within an expression to build complex expression logic. This keeps the mappings more maintainable.
Tip 11:
Never have more than five (5) targets per mapping. This will slow down the mapping exponentially. Complex maps usually demand multiple targets, but the more targets you have, the poorer the performance.
Tip 12:
Complex architectures usually require update strategies within the mapping. The update strategies can result in a performance hit to the session, sometimes significant. It is recommended to minimize the usage of Update Strategies transformations for optimal performance.
Tip 13:
If you have very large and complex mappings that are running with a large amount of data (~50 million+ rows) then it is recommended to use the PowerCenter 64-bit server for optimal performance. It provides you with access to plenty of memory and high speed performance for large mappings.
Tip 14:
Any mapping with 50+ objects is simply too large and MUST be broken down into multiple mappings.
Tip 15:
To create complex output (say a mainframe ASCII file), use a single flat file, single string (4k if necessary), format the string in one or more export "expressions". Use the LPAD and RPAD functions to re-format data, and put record indicator columns on the output side.
Tip 16:
Always set the "master" in the joiner to be the smaller of the two tables (except when using detail outer join or full outer join). This will keep the caching of the two set to the minimum number of rows.
Tip 17:
Replace a lookup with a joiner, whenever you are faced with extremely large data sets
Tip 18:
Use reusable lookups instead of the same lookup multiple times. This will assist in reusing the lookup caches, and improve performance.
Tip 19:
If you are going to use a sequence generator, and share it across multiple mappings (or make the session run in parallel) then set it to cache a minimum of 10,000 values.
Eating Slowly makes you Healthy
In this 21st century speed is everything. Apparently, the slower you eat, the better it is for your health. So says, Dr Yash Paul who has applied to patent this idea.
More details in the Indian Express news item.
Forecasts for 2010
FT's reporters and commentators put out their key forecasts for 2010. Here is an edited version:
Will the UK suffer a double-dip recession? No.
Will the UK government sell any of their stakes in the banking sector?No.
Where will oil finish the year?....oil is most likely to end the year within its present trading range of about $70-$80 a barrel.
Should investors put their money into the stock market?Yes. ...Next year’s stock market gains will be less spectacular than 2009’s.
Will there be a trade war in 2010?Conflict, yes. Full-blown war, no.Will the eurozone experience a sovereign default in 2010? No. ...Since a clean default is impossible, governments will have no choice but to retrench, however painful the consequences.Who should I bet on in the British general election?Forget David Cameron’s Conservatives; pity Gordon Brown’s Labour.
Put your money instead on Nick Clegg’s Liberal Democrats. No, I don’t think Mr Clegg is about to sweep into Downing Street as the leader of the first Liberal government for a century. The firm prospect – to my mind as near a certainty as you can get in politics – is that Mr Cameron will be the next prime minister. But those who fancy a wager should look at the odds on the third party.Will Putin declare his candidacy for Russia’s presidency?Mr Putin will not formally declare his candidacy until closer to the election date but it seems likely that over the next 12 months he will send ever-stronger signals that he intends to run for the presidency in 2012.Will the world make progress on nuclear disarmament? Yes.Will this be the year that Israel bombs Iran’s nuclear installations? No.Will Afghanistan turn into Obama’s Vietnam? No.Will bonuses in Wall Street and the City of London be cut? No.
Will the UK suffer a double-dip recession? No.
Will the UK government sell any of their stakes in the banking sector?No.
Where will oil finish the year?....oil is most likely to end the year within its present trading range of about $70-$80 a barrel.
Should investors put their money into the stock market?Yes. ...Next year’s stock market gains will be less spectacular than 2009’s.
Will there be a trade war in 2010?Conflict, yes. Full-blown war, no.Will the eurozone experience a sovereign default in 2010? No. ...Since a clean default is impossible, governments will have no choice but to retrench, however painful the consequences.Who should I bet on in the British general election?Forget David Cameron’s Conservatives; pity Gordon Brown’s Labour.
Put your money instead on Nick Clegg’s Liberal Democrats. No, I don’t think Mr Clegg is about to sweep into Downing Street as the leader of the first Liberal government for a century. The firm prospect – to my mind as near a certainty as you can get in politics – is that Mr Cameron will be the next prime minister. But those who fancy a wager should look at the odds on the third party.Will Putin declare his candidacy for Russia’s presidency?Mr Putin will not formally declare his candidacy until closer to the election date but it seems likely that over the next 12 months he will send ever-stronger signals that he intends to run for the presidency in 2012.Will the world make progress on nuclear disarmament? Yes.Will this be the year that Israel bombs Iran’s nuclear installations? No.Will Afghanistan turn into Obama’s Vietnam? No.Will bonuses in Wall Street and the City of London be cut? No.
Controversy::All is Well [:)] that Ends well
I have seen the movie, it is really good. I have also read thenovel "Five points Someone" by Chetan Bhagat. I felt that the
characters of the movie are inspired from the book.
The character of Amir Khan is given more importance than
the book.
Subscribe to:
Posts (Atom)