Wednesday, December 5, 2012

INFORMATICA SCENARIOS

INFORMATICA SCENARIOS




1. How to generate sequence numbers using expression transformation?

2. Design a mapping to load the first 3 rows from a flat file into a target?

3. Design a mapping to load the last 3 rows from a flat file into a target?

4. Design a mapping to load the first record from a flat file into one table A, the last record from a flat file into table B and the remaining records into table C?

5.Get top 5 records to target without using rank

6.SEPARATE ROWS ON GROUP BASIS

7.How do you perform incremental logic or Delta or CDC?

8.How to find Date Difference in Hours

9.CURRENCY CONVERTOR

10.CONVERT NUMERIC VALUE TO DATE FORMAT

11.Retrieving first and last record from a table/file


12.Sending first half record to target

13.Sending alternate record to target


14.Separate the original records in target


15.Segregating rows on group count basis


16.Extracting every nth row


17.Sending records to target tables in cyclic order

18.Concatenation of duplicate value by comma separation


19.Target table rows , with each row as sum of all previous rows from source table.

20.Produce files as target with dynamic names

21.Validating all mapping in repository

22.Using mapping parameter and variable in mapping

23.Load the session statistics such as Session Start & End Time, Success Rows, Failed Rows and Rejected Rows etc. into a database table for audit/log purpose.

24.Insert and reject records using update strategy.



















43.What is the difference between view and materialized view?

45.Using Informatica Normalizer Transformation


46.Use of Java Transformation in Informatica


47.How to remove header from a file ?


48.A source table contains emp_name and salary columns. Develop an Informatica  mapping to load all records with 5th highest salary into the target table.


49.We have a target source table containing 3 columns : Col1, Col2 and Col3. There is only 1 row in the table as follows:


50.Q. How do you improve the performance of lookup transformation?


51.Loading Multiple Flat Files


52. What is the difference between Source Qualifier transformations Source Filter to Filter transformation?

53. What is a Source Qualifier? What are the tasks we can perform using a SQ and why it is an ACTIVE transformation?

54. Suppose we have used the Select Distinct and the Number Of Sorted Ports property in the SQ and then we add Custom SQL Query. Explain what will happen.

55. Where we will use the Source Filter, Select Distinct and Number Of Sorted Ports properties of Source Qualifier transformation.

56. Suppose we have two Source Qualifier transformations SQ1 and SQ2 connected to Target tables TGT1 and TGT2 respectively. How do you ensure TGT2 is loaded after TGT1?

57. State the limitations where we cannot use Joiner in the mapping pipeline.

58.Out of the two input pipelines of a joiner, which one will you set as the master pipeline?

59. Suppose we have 100 records coming from the source. Now for a target column population we used a Sequence generator. Suppose the Current Value is 0 and End Value of Sequence generator is set to 80. What will happen

60. Insert the records of those employees who have joined in current month and Reject other rows.

61. Count the no of vowels present in emp_name column of EMP table as shown bellow.

62. The Emp table contains the salary and commission in USD, in the target the com and sal will converted to a given currency prefix ex: Rs.

63. Suppose you are importing a flat file emp.csv and hire_date colummn is in numeric format, like 20101111 .Our objective is convert it to date,with a format 'YYYYMMDD'.

64. Suppose in flat_file some special symbols like @,%,$,#,& has added in empno column along with the actual data. How to remove those special charcters ? ( see article , on how to remove $ from salary )

65. Insert the records of those employees who have joined in current month and Reject other rows.

66. Suppose the source table has values like this 10 A 10 B 10 C 20 X 20 Y 20 Z 30 D 30 E 30 F

67. A source table contains emp_name and salary columns. Develop an Informatica mapping to load all records with 5th highest salary into the target table.

68. Design an Informatica mapping to load first half records to 1 target while other half records to a separate target.

69. How to Change the Session Log Name in Informatica Workflow?

70.Difference between Decode and IIF in Informatica?

71. Difference between Joiner and Union Transformation in Informatica?

72. Difference between Sorter and Aggregator in Informatica?

73. Difference between Sorter and Rank transformation in Informatica?

74. Difference Between DROP, DELETE & TRUNCATE

75. Difference between Trigger and Stored Procedure?

76. Different Between OLTP and OLAP

77. How many stages in Datawarehousing?

78. What are the types of Approach in DWH?

79. Why need staging area for DWH?

71 comments:

  1. Hi kareem this is Shalini from Banglore. These are the scenarios are very useful for Informatica Professionals.

    tou blog is very useful for me thank you once again kareem.

    ReplyDelete
    Replies
    1. Thank Your very much shalini..keep visit my blog..thank u

      Delete
  2. hi Buddy, your blog is very nice ur doing good job.

    ReplyDelete
  3. Hi Kareem,

    This blog is really good...
    Thank u for sharing your knowledge....
    And please keep on posting new questions.

    Regards
    Arpita

    ReplyDelete
    Replies
    1. Thanks Arpita visit my blog for more updates..

      Regards
      kareem

      Delete
  4. Hi kareem this is Sathya, Thanks for u. I am Learning informatica from your blog. Awsome scenarios no need to go for otheres. your blog is really help full for very one thanks lot...

    I have quistion in informatica What is test load?
    If u have a time please leave a rply

    Thanks kareem,
    Sthavya

    ReplyDelete
  5. Excellent Blog......Thanku BROOOO.......Expecting Realtime Project Explanation From U......

    ReplyDelete
  6. Thanks Kareem nice blog and keep on posting with new scenarios

    ReplyDelete
  7. Hi Kareem,

    This is sravan Thank you very much
    This blog is useful

    ReplyDelete
  8. Hi,
    I am using a flat file.
    the sequence is in this way:
    Flat File - Source Qualifier - target.
    Is there any way to filter out rows from source qualifier, nowing that the source is a flat file?

    ReplyDelete
  9. Hi,
    I am using a flat file.
    the sequence is in this way:
    Flat File - Source Qualifier - target.
    Is there any way to filter out rows from source qualifier, knowing that the source is a flat file?

    ReplyDelete
  10. Hi Kareem, i have faced the following scenario in my recent interview.Please post the solution it will be very useful me in future.

    I have 1 source and 4 target as below. How to achieve the load from source to target as below:
    Source
    Id
    A
    B
    B
    C
    C
    C
    D
    D
    D
    D
    Target1
    ID
    A
    Target2
    ID
    B
    B
    Target3
    C
    C
    C
    Target4
    D
    D
    D
    D

    ReplyDelete
    Replies
    1. its very simple dude .place 1 router transformation after source qualifier and write the conditions as below.

      group 1 Id='A'
      group 2 Id='B'
      group 3 Id='C'
      group 4 Id='D'

      connect to the target.

      thats it....

      Delete
  11. hi kareem, i have faced this question in my interview............suppose yesterday i run a session,it took 2 mints to run bt when today i run the same session,its in running mode only..... wats the reason for this???? pls rply dis........

    ReplyDelete
  12. Hi kareem,

    i am narayana,nice blog, It is useful for me.
    I have some questions.

    1)wat is partition optimization?
    2)wat is starter?

    I am waiting ur reply.
    Thank you

    ReplyDelete
  13. Hi Sir,
    i have scenario
    i have a target table which loads transaction data, after 4th time
    execution of workflow i need to delete oldest execution data means
    i have to maintain last 3 executions of data only(Not on date basis)
    ex:on 1st execution a
    on 2nd execution a
    b
    on 3rd execution a
    b
    c
    on 4st execution
    b
    c
    d
    on 5th execution
    c
    d
    e
    plz help me

    ReplyDelete
  14. Hi Kareem,
    Can you please help me in that scenario

    Thanks

    ReplyDelete
  15. hi kareem
    how to load first half recods into one target table and second half into another target table if source is flat file
    please helpme

    ReplyDelete
  16. As I am fresher I have an interest in new technology.so,now I am planning to learn Informatica in your blog i had some interesting concepts, it was crystal clear to read keep sharing thanks from Informatica training in chennai

    ReplyDelete
  17. 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.
    Regards,

    sas training in Chennai

    ReplyDelete
  18. Nice Article..!!!
    Thanks for sharing with us
    To learn Informatica visit below link-
    http://tekclasses.in/

    ReplyDelete
  19. Can you please add some more new realtime scenarios we will share it our students to watch your space

    Informatica online training

    informatica online training

    ReplyDelete
  20. Actually I like yourblog, Thanks for sharing this pretty information with us, keep on blogging
    Regards,
    Informatica training in chennai|Informatica training center in Chennai

    ReplyDelete
  21. Hi Admin
    Thanks for your informative article. Keep on sharing your blog with awesome information. SAS Training in Chennai| SAS Course in Chennai

    ReplyDelete
  22. Thanks for your great information… your blogs make me to explore more about Informatica. The Author has shared Informatica scenarios. I like this blog and it’s very informative. I had found one more website related to Informatica course. If you want to learn more about informatica just have a look: https://goo.gl/whaLnK

    ReplyDelete
  23. Well defined blog..
    Visit our site for more details
    http://hungerlion.com/

    ReplyDelete
  24. very nice information.the best informatica training in chennai»the best informatica training in chennai.

    ReplyDelete
  25. After looking into a handful of the bog articles on your site, I really like your technique of writing a blog. I
    book marked it to my bookmark site list and will be checking back in the near future. Take a look at my website as well and let me know your opinion.
    Informatica Training in Chennai

    ReplyDelete
  26. Thank you for your great information on informatica online trainings.
    Informatica Online Course!

    ReplyDelete
  27. Awesome information thanks for sharing
    Informatica online training

    ReplyDelete
  28. Truly a very good article on how to handle the future technology. After reading your post,thanks for taking the time to discuss this, I feel happy about and I love learning more about this topic. Torusinfotech is one of the Bwst SEO Company in Delhi, India and low cost SEO service providers. Our low cost SEO service is a great way to start with our service and experience the change in your business...SEO Training Institute in Delhi

    ReplyDelete
  29. Croma campus placed in different places in noida. We are the best Training Institute offers certification orient Informatica Training in Noida. Our participant will be qualified to clear all type of interviews at end of our session. We are structure a team of Informatica trainers and participant for their hope help and support in subject.

    ReplyDelete
  30. I frankely say your artical contain different type of topics.That can used to select the related topics. Thanks for sharing this type of blogs.


    SAS Training in Bangalore

    ReplyDelete

  31. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharng this information,this is useful to me...
    Android Training in Chennai
    Ios Training in Chennai

    ReplyDelete
  32. Are You Getting Your Training From an Authorized Provider?
    We make absolutely sure that your training facility is authorized to provide a Pearson Vue Exam Certificate. Pearson Vue Exam Center in Bangalore |
    Pearson Vue Exam Centers in Bangalore |

    ReplyDelete
  33. nice post i just wanted to bookmark this blog thanks for giving this type of questions.it is very important.whenever learning about the informatica course.thanks for giving this kind of information me..

    Informatica training in chennai

    ReplyDelete
  34. This Blog Is Reayally Good...Thank You For Sharing This Knowledge....keep sharing this type of information..Informatica Online Training In Hyderabad

    ReplyDelete
  35. Thanks for one marvelous posting! I enjoyed reading it; you are a great author. I will make sure to bookmark your blog and may come back someday. I want to encourage that you continue your great posts, have a nice weekend! Besant Technologies offers the best Hadoop Training in Bangalore with the guide of the most gifted and all around experienced experts.

    ReplyDelete
  36. Informatica Training in Noida Provides by Croma Campus is best training institute in noida and real time working profession trainer with job placement support. So more details call now +91-7503121768

    ReplyDelete
  37. fabulous information you have shared, I would like to say thanks for you. Please share more valuable content on msbi online course bangalore

    ReplyDelete
  38. Its a wonderful post and very helpful, thanks for all this information.
    Informatica Training in Noida

    ReplyDelete
  39. The article is so informative. This is more helpful for our. oracle training in chennai

    ReplyDelete
  40. Hi Kareem,
    Very nice post on Informatica Online Training. It is very useful post and I will make sure to share this one.

    ReplyDelete
  41. Title:
    Top Oracle Training in Chennai | Infycle Technologies

    Description:
    Infycle Technologies is the best software training institute in Chennai, which offers amazing Oracle training in Chennai in 100% practical training with experienced trainers in the field. Apart from the training, the mock interviews will be arranged for the students, so that, they can face the interviews without any struggles. Of all that, complete placement assurance will be given in top MNC's. For more details, call 7502633633 to Infycle Technologies and grab a free demo to know more.
    Top Oracle Institute in Chennai

    ReplyDelete
  42. Infycle Technologies, the best
    software training institute in Chennai
    offers the No.1 Python Certification in Chennai for tech professionals. Apart from the Python Course, other courses such as Oracle, Java, Hadoop, Selenium, Android, and iOS Development, Big Data will also be trained with 100% hands-on training. After the completion of training, the students will be sent for placement interviews in the core MNC's. Dial 7502633633 to get more info and a free demo.

    ReplyDelete
  43. Really you have done a good job. Thanks for sharing this valuable information....
    Informatica Power Center
    Informatica PowerCenter Latest Version

    ReplyDelete
  44. Technologies is one of the best Oracle Training Institute in Chennai, which offers various programs in Oracle such as Oracle PLSQL, Oracle DBA, etc., in the 200% hands-on practical training with specialized trainers in the field. In addition to that, the mock interviews will be arranged for the candidates, so that, they can face the interviews without any fear. Of all that, 100% placement assurance will be given here. To have the words above in the real world, call 7502633633 to Infycle Technologies and grab a free demo to know more.
    BEST TRAINING IN CHENNAI

    ReplyDelete
  45. Thanks for sharing the informative article. It's very useful for beginners. the info it solution offers the best and affordable SEO services, provider. You can take their services

    digital marketing agency

    ReplyDelete
  46. Finish the Selenium Training in Chennai from Infycle Technologies, No.1 software training institute in Chennai which is providing professional courses for students, freshers, experienced, and tech professionals. We provide courses like DevOps, Artificial Intelligence, Cyber Security, Python, Oracle, Java, Power BI, Digital Marketing, Data Science, etc. with the best trainers receiving amazing training for the best career. For more details and demo classes call 7504633633.

    ReplyDelete
  47. Looking for a water park in Gurgaon? Appughar Gurgaon best option. We have the perfect place for you and your friends to enjoy some fun in the sun. water park in Gurgaon has everything you could ask for - slides, pools, and even a lazy river to float down. See Offers. Check Events. View Gallery. Book Now.

    ReplyDelete
  48. Are you looking for the best Astrologer in Gurgaon? Well, MahaKali Jyotish Kendra is one of the most famous and experienced astrologers in Gurgaon. he solves the love problem solution And love marriage problem solution specialist, For more information contact us:-9818321754.

    ReplyDelete

Thank you :
- kareem