Results 1 to 16 of 16

Thread: Typical Informatica Scenarios

  1. #1
    Moderator
    Join Date
    Oct 2005
    Answers
    305

    Typical Informatica Scenarios

    Hi, Can any one please tell me some of the typical scenarios they faced at work in Informatica and what measures they took to over come them. Thanks in advance!!

    NOTE : [This question was asked by lakshmi]


  2. #2
    Junior Member
    Join Date
    Apr 2007
    Answers
    4

    Re: Typical Informatica Scenarios

    Good Question
    I am also requring this question answer.Can any body tell me what are the typical informatica scenorios and what are complex mappings?
    Pllz ..Thanks in advance


  3. #3
    I am the DON
    Join Date
    Apr 2006
    Answers
    99

    Re: Typical Informatica Scenarios

    Quote Originally Posted by jagadishwar View Post
    Good Question
    I am also requring this question answer.Can any body tell me what are the typical informatica scenorios and what are complex mappings?
    Pllz ..Thanks in advance
    If you are having some typical scenarios, Anybody can discuss and give some suggestions. But it is great that the Geek has to post the Scenario and expalin each and every thing.

    Just funny..? And Moderator started this...?

    If you any such scenarios like that, Keep posting here and get response..

    Sanghala


    Sanghala

    If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.

  4. #4
    Moderator
    Join Date
    Oct 2005
    Answers
    305

    Re: Typical Informatica Scenarios

    Sanghala It is mentioned in the thread. The question is asked by a visitor to this site.


  5. #5
    I am the DON
    Join Date
    Apr 2006
    Answers
    99

    Re: Typical Informatica Scenarios

    Quote Originally Posted by Lokesh M View Post
    Sanghala It is mentioned in the thread. The question is asked by a visitor to this site.
    Lokesh,

    I am not misleading anyone by replying like that.
    My intension is that you can ask that to gost the typical scenarios that he/she has...! Then all Geeks will try to solve them.

    This is I mean to say... Hope, this kind of threads are against the Forum Rules as they will be no meaning for getting different scenarios as different thread and for searching that will be easy.

    So My suggestion is to close this thread and Keep posting as different threads for each and every sceanario.

    If it hurts anyone - Sorry from my side.

    Sanghala


    Sanghala

    If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.

  6. #6
    Moderator
    Join Date
    Oct 2005
    Answers
    305

    Re: Typical Informatica Scenarios

    Sanghala,

    May be I interpret the question differently.

    To me it appears the visitor to be a fresher. A novice who is just seeking to have a glimpse of a Typical Informatica Scenario, with practically no prior experience with it.

    Nope, I did not feel hurt, so no sorry

    Regards,
    Lokesh M.

    Last edited by Lokesh M; 08-16-2007 at 08:23 AM.

  7. #7
    Junior Member
    Join Date
    Oct 2009
    Answers
    1

    Re: Typical Informatica Scenarios

    Hi Can any one explain me how to populate duplicate recs and Unique recs in flatfiles thro Informatica


  8. #8
    I am the DON
    Join Date
    Apr 2006
    Answers
    99

    Thumbs up Re: Typical Informatica Scenarios

    Quote Originally Posted by kripa5000 View Post
    Hi Can any one explain me how to populate duplicate recs and Unique recs in flatfiles thro Informatica
    Hey Kripa,

    Source is a faltfile and want to load unique and duplicate records separately into two separate targets; right ??

    Here comes the solution -
    SRC - SQ_SRC - SRT - EXP - RTR - TGT

    Try with the above and add logic of Sorter to identify duplicates, Use expression to mark the duplicates and finally Router to route to different targets.

    Create the logic - Here just i have given the idea, implement and get succeed yourself. Have any questions, reach me.

    Sanghala

    If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.

  9. #9
    Junior Member
    Join Date
    May 2010
    Answers
    1

    Re: Typical Informatica Scenarios

    Scenario 2:

    Have to load every nth row from a Flat file to the target. How do i do that?


  10. #10
    Junior Member
    Join Date
    Jul 2010
    Answers
    4

    Re: Typical Informatica Scenarios

    Have to load every nth row from a Flat file to the target. How do i do that?


  11. #11

    Re: Typical Informatica Scenarios

    Hi friends,
    i want to know about scenarios in informatica for interview purpos
    please send some examples
    thank'Q'


  12. #12

    Re: Typical Informatica Scenarios

    how to get n th record in every flatfile to target?


  13. #13

    Thumbs up Re: Have to load every nth row from a Flat file to the target. How do i do that?

    Hi Thekey/Ahammed/Sudheer,

    Below is the solution of the Scenario (nth Row Load):

    SRC--->SQ_SRC--->Seq_Gen--->Flt--->Tgt

    In the Filter (Include all the columns of SQ and 1 from SEQ_GEN), U need to give the condition like:

    iif(CURR_VALUE % n = 0)

    Suppose n=3, then in above condition the row numbered 3,6,9,12,....so on. Will only satisfy the Filter criteria and will be loaded to Target.

    Please let me know, in case any further issue or concerns if u face!

    Regards,
    Harish Verma.

    Last edited by harish_9873857538; 09-28-2010 at 02:36 AM.

  14. #14
    Junior Member
    Join Date
    Sep 2010
    Answers
    1

    Re: Typical Informatica Scenarios

    How to Establish connection to SQL Server from informatica.


  15. #15
    Junior Member
    Join Date
    Oct 2010
    Answers
    4

    Re: Typical Informatica Scenarios

    Kripa,

    Duplicate Records : There no need to do any thing jus Do not use look up table
    with removal Look up table all you Source rows will append to existing record which will create duplicacy

    Unique Records: Use Sorter after the Source Qualifer and Check "Distinct in Properties" ....This will provide you the Unique recorde


  16. #16
    Junior Member
    Join Date
    Oct 2010
    Answers
    4

    Re: Typical Informatica Scenarios

    SRC - SQ_SRC - EXP - FIL- TGT

    Go with this logic...Every thing will be loaded in TARGET table


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact