Thursday, November 6, 2014

Dig a Little Deeper


Be sure to separate symptoms of a problem from the problem itself.  This can sometimes be harder than it seems.  Sometimes the problem is a few layers below the surface.  For example, assume you get the following issue reports and feature requests:
1.     Please add a button to all list screens to export data to Excel.
2.     Whenever running a query that returns a lot of data (e.g. 10K rows) the list screens take a long time to return.
3.     We’d like to be able to run very basic (read-only) queries by linking to some tables through MS Access.  But in order to do that we need an Oracle client installed on our machine.  We also need a username/password for the database.
4.     Please add “week ending” and “month” to the return fields for all list screens.
On the surface these seem like simple, disparate problems to be solved.  So you might come up with solutions like this:
1.     “Sure – we can add an export button”.
2.     “Hmmm – we’ll have to look at the query – maybe it can be tuned.”
3.     “A little unorthodox.  We’ll have to get approval from IT management that this is ok but this is not technically challenging”.
4.     “Sure – easy enough”
But if we look a little deeper we can see that these are symptoms of a deeper problem: the users do not have an easy way to perform management reporting and data analysis.  Neither this system nor other systems (e.g. a data warehouse) are addressing these business needs.  Think about it.  Here is a different way of looking at each of the issues:
1.     Adding an export button is fairly harmless but the reason they need it is probably because they are doing analysis in Excel that the system is not helping them with.
2.     There’s no way they’re reading through 10K lines of data line-by-line.  The reason they’re doing this is probably because they’re analyzing the data in ways that the system does not support.
3.     There’s no way they’d be desperate enough to navigate the oddities of our back-end if the system better supported their analytical needs.
4.     Hmmm.  I am guessing they want those fields for time-trend reporting or filtering.  This suggests that they’re doing their analysis off of large report results which is another symptom of the fact that the system does not support their analytical needs.
Whenever possible focus on ideas to treat the problem not the symptoms.  Treating symptoms is ok as a short-term alternative but it is rarely the way to go in the long-term.  To use a medical analogy cough syrup is useful and may effectively treat the symptoms of an infection but antibiotics have the capability to address the root cause.  Dig a little deeper and be sure you get to the underlying problem.

102 comments:

  1. I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.
    Regards,
    Best Informatica Training center In Chennai|Informatica training center chennai

    ReplyDelete
    Replies
    1. I am technology Enthusiast. Your blog is really awesome, attractive and impressive. I like the way you think. it is very useful for Java SE & Java EE Learners. Your article adds best knowledge to our Java Online Training in India. or learn thru Java Online Training in India Students. or learn thru JavaScript Online Training in India. Appreciating the persistence you put into your blog and detailed information you provide. Kindly keep blogging.

      Delete
  2. too good piece of information, I had come to know about your site from my friend sajid, bangalore,i have read atleast 7 posts of yours by now, and let me tell you, your web-page gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new post, once again hats off to you! Thanks a lot once again, Regards, informatica mdm training in hyderabad,informatica training in hyderabad

    ReplyDelete
  3. Thank you for sharing this knowledge in a blogpost.Really simple and even more effective and this worked great, very useful tips
    Informatica training in Hyderabad

    ReplyDelete
  4. Wow! In the end I got a webpage from where I be capable of truly get useful information regarding my study and knowledge.

    Informatica Training
    Hadoop Training
    Tableau Training
    Angularjs Training
    SAP Success Factors Training
    Unix Shell Scripting Training

    ReplyDelete
  5. I have been reading out a lot of your articles.
    I will certainly bookmark your Blog.
    Hybris Training

    ReplyDelete
  6. Awesome blog! I gained some knowledge with the help of your blog so, I am suggesting your blog to my friends. Keep updating. Software Testing Training in Chennai | Java Training in Chennai

    ReplyDelete
  7. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…
    Selenium Training in Chennai
    Selenium Training Course in Chennai

    ReplyDelete
  8. Nice post. Very interesting to read. Thank you for Sharing.
    erp software in chennai

    ReplyDelete
  9. This post was quite awesome and interesting to read. Congrats for your work. Thanks a lot for providing this with us. Keep on updating this with us regularly.
    Film editing course in chennai

    ReplyDelete
  10. wow! what a excellent topic "Dig Little Deeper"., Really nice to read. Thank you for share such a new post. Dot Net Training in Chennai | Java Training in Chennai

    ReplyDelete
  11. Awesome Blog, you have provided the right information that will be beneficial to us. Thanks for sharing your valuable Ideas to our vision... Automation Anywhere Training in Chennai | RPA Training Institute in Chennai | UI Path Training Institute in Chennai

    ReplyDelete
  12. Hi Buddy,

    Great post.
    Can’t get any more
    straight forward than this article. Thanks!


    Does informatica metadata manager 10.1.1 support cognos analytics resource version 11.?

    if yes, how to add Cognos analytics resource to current meta data manager.?

    Anyways great write up, your efforts are much appreciated.
    Ciao,
    Yashwanth

    ReplyDelete
  13. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.
    aws training in Chennai

    ReplyDelete
  14. Hi There,


    You make learning and reading addictive. All eyes fixed on you. Thank you being such a good and trust worthy guide.

    We are working on integration of SFDC (SalesForce CRM) with Exact Target(ET) (SalesForce Marketing Clound) through Informatica PowerCenter 9.5.1.
    But facing below issues:
    1) While importing SalesForce object into PowerCenter : Getting an error "timed out"
    2) How to connect to Exact target from power Center using API (we tested this from Java by passing proxy to webservie but not sure how to pass proxy to webservice in power Center)

    Awesome! Thanks for putting this all in one place. Very useful!


    Many Thanks,
    Kevin

    ReplyDelete
  15. Awesome Blog with Smart Content, really I enjoyed while reading your blog. Thanks for sharing such a nice blog.
    Summer Course Training Institute in Chennai | Summer Course Training Institute in Meenambakkam

    ReplyDelete
  16. Terrific post but I was wanting to know if you could write a title more on this subject? I’d be very grateful if you could elaborate a little bit further. Many thanks!
    Good Vecation classes in Chennai | Best Summer Course in Guindy

    ReplyDelete
  17. Hello,

    This is the most brilliant article ever! Please put the permalink part in the post. If someone didn’t comment on it I’d have no idea!

    I have created 3 entities from Provisioning tool (Person, Address ,Organisation) validated and published changes to MDM database.
    Now when i accessed on /cmx/csfiles on the browser, I got a list of services offered for that particular schema, and I imported the WSDL file into SOAP, I was able to see the web services for these entities.
    But the problem is there are many unwanted parameters in the SOAP request. My goal is to provide this WSDL to downstream systems and they are trying to access the web services through this WSDL but too many parameters which are unwanted .

    Appreciate your effort for making such useful blogs and helping the community.

    Obrigado,
    Irene Hynes

    ReplyDelete
  18. I simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site.
    rpa training in chennai

    ReplyDelete
  19. Hi There,

    Thanks for the tip, appreciate it. Your article definitely helped me to understand the core concepts.
    I’m most excited about the details your article touch based! I assume it doesn’t come out of the box, Informatica MDM Training it sounds like you are saying we’d need to write in the handlers ourselves.
    Is there any other articles you would recommend to understand this better?

    pkey_src is something different for different source. Update to the BO happens when pkey_src of Source A is there in the stage and it matches with the BO_XREF and update happens.
    But if the same record came in from a different source for the first time then the pkey_src will be different and there will be no match with BO_XREF. What will happen in this scenario? Will there a new record insert in BO along BO_XREF.
    Could you please let me know if this is correct and how hub works in this case?
    Appreciate your effort for making such useful blogs and helping the community.

    Regards,
    Preethi.

    ReplyDelete
  20. Hi Joseph,

    That’s really cool…. I followed these instructions and it was like boom… it worked well..


    Update for BO or XREF ? If the trust is less than what it is already have,

    then it will update XREF and not BO. Informatica MDM Training

    By the way do you have any YouTube videos, would love to watch it. I would like to connect you on LinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues).

    Please keep providing such valuable information.

    Thank you,
    Irene Hynes

    ReplyDelete
  21. It is a one of the great discussion which is very essential for me as well. I must follow the handy discussion and sure that the content will be very useful to me as well. Keep it up.
    Tata Sky New Connection | Tata Sky DTH | Tata Sky DTH New Connection

    ReplyDelete
  22. Nice post.Thanks for sharing this post .I really appreciate the kind of topics you post here.
    manufacturing erp software in chennai

    ReplyDelete
  23. The price you pay for window cleaning depends on the area, London generally charges more especially if you are in central London or a congestion charging zone. solar for home buyers

    ReplyDelete
  24. Great Article...Thanks for sharing the best information.It was so good to read and useful to improve my knowledge as updated one.

    Tableau Training in Chennai
    Tableau Training

    ReplyDelete
  25. Amazing Article ! I have bookmarked this article page as i received good information from this. All the best for the upcoming articles. I will be waiting for your new articles. Thank You ! Kindly Visit Us @ Coimbatore Travels | Ooty Travels | Coimbatore Airport Taxi | Coimbatore taxi

    ReplyDelete
  26. Today, the the term 'computer software' means written programs, rules, or codes, along with related documentation regarding the operation of a computer system that is stored in read/write memory..hard drive recovery tool

    ReplyDelete
  27. Let's play together on the website of the online casino BGAOC. great gambling sites Do not miss the chance to win with us.

    ReplyDelete
  28. Nice article i was really impressed by seeing this article, it was very interesting and it is very useful for me.

    dgreatwallofchina
    Article submission sites

    ReplyDelete
  29. Modest, quick and proficient are just a couple of the advantages you may encounter utilizing a product recovery device effectively. UK data recovery

    ReplyDelete
  30. very nice blogs!!! i have to learning for lot of information for this sites...Sharing for wonderful information. Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing

    Best AWS Training Academy in Kanchipuram

    ReplyDelete
  31. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…

    Best Web Designing Training Academy in Kanchipuram

    ReplyDelete

  32. I like your post very much. It is very much useful for my research. I hope you to share more info about this. Keep posting!!
    Best Devops Training Institute

    ReplyDelete
  33. Your article was so impressive and informative. Its very interesting to read. Thanks for sharing,
    Best web design Training Institute in Kanchipuram

    ReplyDelete
  34. Home Mart is a site about Home Improvement, Furniture, Home Appliances and many more.
    Check out the best
    Dog Cages
    bedroom furniture nz
    entertainment unit
    shoe rack

    ReplyDelete
  35. I am really enjoying reading your well-written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work.
    VMware Training in Chennai
    VMware Training
    Vmware cloud certification
    R Training in Chennai
    RPA Training in Chennai
    DevOps certification in Chennai
    VMWare Training in Anna Nagar
    VMWare Training in T Nagar
    VMWare Training in Adyar

    ReplyDelete
  36. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge.

    MatLab Training Institute in Chennai | MatLab Training in Velachery | MatLab Courses in Medavakkam

    ReplyDelete
  37. Your Blog is really awesome with useful information and informative article.Thanks for sharing such a wonderful and excellent post with us.keep updating such a amazing post..
    ISTQB Certification Training Center in Chennai | ISTQB Certification Exams in Velachery | ISTQB Certification Training in Velachery | ISTQB Certification Exams in Madipakkam

    ReplyDelete
  38. Thanks for sharing your wonderful and very useful information.keep updating such a impressive and attractive blog with interesting content.

    Java Training in Chennai | Java Training in Velachery | Java Training Center in Medvakkam | Java Training in Pallikaranai | Java Courses in Chennai | Java Online Training in Guindy

    ReplyDelete
  39. Good article!!! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…

    Best UI Path Training Institute in Chennai | Best UI Path Training in Velachery | Best UI Path Certification Training in Pallikaranai

    ReplyDelete
  40. Thanks for sharing your informative blog with useful information,its really very interesting and happy to read your article.keep updating such a wonderful post with us..

    Embedded System Training in Chennai | Embedded Training in Velachery | Embedded Training Institute in Pallikaranai

    ReplyDelete

  41. Your Blog is really amazing; it’s really very informative content and useful information. Thanks for sharing your wonderful blog. Keep updating such a creative knowledge.

    Best Java Training Institute in Chenna | Java Training in Velachery | Best Java Courses in Medavakkam | Java Training Center in Pallikaranai

    ReplyDelete
  42. Your Blog is really amazing,its really useful for me and informative content with helpful information.keep updating such a wonderful post..

    Tally ERP9 Training in Chennai | Best Tally Training in Chennai | Tally Training Center in Pallikaranai | No.1 Tally ERP9 with GST Courses in Velachery

    ReplyDelete
  43. Very informative blog. Helps to gain knowledge about new concepts and techniques.Thanks a lot for sharing this wonderful blog.keep updating such a excellent post..

    Best PCB Design Training in Chennai | No.1 PCB Design Course in Velachery | Best PCB Training in Chennai

    ReplyDelete
  44. Nice blog. Thank you for sharing. The information you shared is very effective for learners I have got some important suggestions from it..
    Python Certification Training Institute in Chennai | Python Training in Chennai | Python Exam Center in Velachery | Python Training in Velachery

    ReplyDelete
  45. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...

    AWS Certification Training Institute in Chennai | AWS Training Center in Chennai | AWS Certification Training in Velachery

    ReplyDelete
  46. Thanks for sharing this information,this is helpful to me a lot...It is amazing and wonderful to visit your site.

    Web Designing Training Institute in Chennai | Web designing Training in Velachery | Web Design Training Center in Velachery

    ReplyDelete
  47. Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing.
    Best MicroSoft Azure Training Institute in Chennai | Azure Training in Pallikaranai | Best Azure Certification Training in Pallikaranai | Best Azure Training Center in Chennai

    ReplyDelete
  48. This is a great inspiring article.I am pretty much pleased with your good work. You put really very helpful information. Keep it up. Keep blogging. Looking to reading your next post..

    Best ISTQB Certification Training in Chennai | No.1 ISTQB Certification Training Center in Chennai | ISTQB Certification Exam Center in Velachery | ISTQB Certification Training in Saidapet

    ReplyDelete
  49. Thank you so much for posting this. I really appreciate your work. Keep it up. Great work! I am really interested to continue reading your blog. You have shared valid info. Waiting for more updates from you.
    AWS Certification Training in Chennai | Best AWS Training Institute in Chennai | No.1 AWS Certification Training in Nanganallur | AWS Training in Velachery

    ReplyDelete
  50. It is awesome and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    PCB Design Training Institute in Chennai | PCB Designing Training in Velachery | PCB Design in Pallikaranai | PCB Course in Chennai

    ReplyDelete
  51. Good article! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…
    Python Certification Training in Chennai | Python Training Institute in Velachery | Python Certification Exams in Chennai | Python Exam Center in Chennai

    ReplyDelete
  52. Wow...What an excellent informative blog, really helpful. Thank you so much for sharing such a wonderful article with us.keep updating..

    MatLab Training Institute in Chennai | MatLab Training in Velachery | Matlab Training Center in Chennai | MatLab Courses in Pallikaranai | MatLab Training with Placement in Chennai

    ReplyDelete
  53. I feel really happy to see your blog and look forward to many more entertaining times reading here. Thanks once more for all the details.

    Java Training institute in Chennai | Java Training Center in Chennai | Java Courses in Velachery

    ReplyDelete
  54. I feel really happy to see your blog and look forward to many more entertaining times reading here. Thanks once more for all the details.

    Java Training institute in Chennai | Java Training Center in Chennai | Java Courses in Velachery

    ReplyDelete
  55. It is awesome and wonderful to visit your site.Thanks for sharing your ideas and views... keep rocks and updating........
    Tally ERP9 Training Institute in Chennai | Tally Training Center in Velachery | Tally Training Center in Taramani

    ReplyDelete
  56. It is awesome and wonderful to visit your site.Thanks for sharing your ideas and views... keep rocks and updating........
    Tally ERP9 Training Institute in Chennai | Tally Training Center in Velachery | Tally Training Center in Taramani

    ReplyDelete
  57. Thanks for posting this useful content, Good to know about new things here.It was so good to read and useful to improve my knowledge as updated one, keep blogging…
    MicroSoft Azure Training Institute in Chennai | Azure Certification Training in Velachery | Azure Certification Training in Adyar

    ReplyDelete
  58. Thanks for posting this useful content, Good to know about new things here.It was so good to read and useful to improve my knowledge as updated one, keep blogging…
    MicroSoft Azure Training Institute in Chennai | Azure Certification Training in Velachery | Azure Certification Training in Adyar

    ReplyDelete
  59. I have read your blog its very attractive and impressive. I like it your blog.Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge.

    VMware Certification Training in Chennai | VMware Certification Exam Center in Chennai | VMware Exams Center in Taramani | VMware Certification Exams in Chennai

    ReplyDelete
  60. I have read your blog its very attractive and impressive. I like it your blog.Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge.

    VMware Certification Training in Chennai | VMware Certification Exam Center in Chennai | VMware Exams Center in Taramani | VMware Certification Exams in Chennai

    ReplyDelete
  61. Wow...What an excellent informative blog, really helpful. Thank you so much for sharing such a wonderful post with us.keep updating..
    AWS Certifications in Chennai | AWS Exam Centers in Chennai | AWS Certification Exams in Velachery | AWS Exams in Velachery | AWS Online Exam Center in Velachery

    ReplyDelete
  62. Wow...What an excellent informative blog, really helpful. Thank you so much for sharing such a wonderful post with us.keep updating..
    AWS Certifications in Chennai | AWS Exam Centers in Chennai | AWS Certification Exams in Velachery | AWS Exams in Velachery | AWS Online Exam Center in Velachery

    ReplyDelete
  63. Very informative and interesting blog, it was so good to read and useful to improve my knowledge as updated one,keep updating..This Concepts is very nice Thanks for sharing.
    ISTQB Certification in Chennai | ISTQB Exam Centers in Chennai | Best ISTQB Exams in Velachery

    ReplyDelete
  64. Very informative and interesting blog, it was so good to read and useful to improve my knowledge as updated one,keep updating..This Concepts is very nice Thanks for sharing.
    ISTQB Certification in Chennai | ISTQB Exam Centers in Chennai | Best ISTQB Exams in Velachery

    ReplyDelete
  65. It is really very awesome and wonderful to visit your site.Thanks for sharing your informative blog with us.keep updating such a wonderful post..
    MicroSoft Azure Certification in Chennai | Azure Exam Centers in Velachery | Azure Exam Centers in Madipakkam

    ReplyDelete
  66. It is really very awesome and wonderful to visit your site.Thanks for sharing your informative blog with us.keep updating such a wonderful post..
    MicroSoft Azure Certification in Chennai | Azure Exam Centers in Velachery | Azure Exam Centers in Madipakkam

    ReplyDelete
  67. Your Blog is really amazing with useful and helpful content for us.Thanks for sharing.keep updating more information.
    Embedded System Training Institute in Chennai | Embedded Training in Velachery | Embedded System Training in Guindy

    ReplyDelete
  68. Your Blog is really amazing with useful and helpful content for us.Thanks for sharing.keep updating more information.
    Embedded System Training Institute in Chennai | Embedded Training in Velachery | Embedded System Training in Guindy

    ReplyDelete
  69. Impressive blog with lovely information. really very useful article for us thanks for sharing such a wonderful blog...
    Java Training institute in Chennai | Java Certification Training Center in Velachery | Java Training in Pallikaranai

    ReplyDelete
  70. Impressive blog with lovely information. really very useful article for us thanks for sharing such a wonderful blog...
    Java Training institute in Chennai | Java Certification Training Center in Velachery | Java Training in Pallikaranai

    ReplyDelete
  71. Nice Post! It is really interesting to read from the beginning and Keep up the good work and continue sharing like this.
    Linux Training Institute in Chennai | Linux Certification Training in Velachery

    ReplyDelete
  72. Nice Post! It is really interesting to read from the beginning and Keep up the good work and continue sharing like this.
    Linux Training Institute in Chennai | Linux Certification Training in Velachery

    ReplyDelete
  73. Excellent Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge.
    Java Training Institute in Chennai | Java Certification Training in Velachery

    ReplyDelete