Results 1 to 15 of 15

Thread: informatica

  1. #1
    Junior Member
    Join Date
    Sep 2007
    Answers
    2

    informatica

    why lookup transformation is passive?


  2. #2
    Junior Member
    Join Date
    Sep 2007
    Answers
    2

    Re: informatica

    why lookup transformation is passive?


  3. #3
    Contributing Member
    Join Date
    May 2007
    Answers
    45

    Re: informatica

    Look up transformation is Passive because for each input row must get one output value (whether it is look up value or null).

    Thx
    SRIRAM N
    Hope Everything Good

  4. #4

    Re: informatica

    what is sorogate key and production key in informatica.


  5. #5

    Re: informatica

    How manay types of transformation in informatica and what are they.


  6. #6

    Re: informatica

    What is STAR schema and snowflake schems.who is better.and what is the difference between them.


  7. #7

    Re: informatica

    what is the latest version of informatica.


  8. #8
    Contributing Member
    Join Date
    Dec 2007
    Answers
    34

    Re: informatica

    Informatica 8.1


  9. #9
    Junior Member
    Join Date
    Feb 2008
    Answers
    1

    Re: informatica

    Quote Originally Posted by sunil8816 View Post
    why lookup transformation is passive?
    the lookup transf.. is used to look up data in relational tables, views e.t.c so here there is no change in the number of rows while data is flowing from source to target. so it is a passive transf...

    please correct me if i am mistaken...

    thks
    thanesh


  10. #10
    Junior Member
    Join Date
    Mar 2008
    Answers
    4

    Re:surrogate key

    it is an system generated key,which is uniquily identified by either entity or the object


    can any one say what is an production key


  11. #11
    Junior Member
    Join Date
    Mar 2008
    Answers
    4

    Re: informatica(star scheema/snowflake scheema)

    star scheemane fact table is surrounded by four dimension tables,the data in this is denormalised data, all facts are numeric, but not all numerics are the facts . the numeric with KPI(Key Performance Indicter) is only the fact
    use: if we want to calculate the total table report it is very usefull

    snowflake scheema:fact table is divided into number of dimension tables getting the data is nomalised, and it has a parenr_child key relation ship also
    use:if we want to calculate each table report,it is usefull


  12. #12
    Junior Member
    Join Date
    Mar 2008
    Answers
    15

    Re: informatica

    Look-up transformation just does look-up on the source,target table etc..Look-up is passive as it doesnot change the no.of rows passing through it.


  13. #13
    Junior Member
    Join Date
    Nov 2008
    Answers
    1

    Re: informatica

    Star schema - A centralized fact Table with or without measures connected to corresponding dimension tables in such a way that the topology appears like a star.its basically based on denormalized tables.
    Snow schema in dwh env uses third normal form rather than star schema which uses a denornalized structure.Snowflake schemas normalize dimensions to eliminate redundancy.that's instead of One large table.
    Ex: Location Dimension in star schema might be normalized into Locationa dn city tables in Snow flake schema.


  14. #14
    Junior Member
    Join Date
    Nov 2008
    Answers
    2

    Re: informatica

    what is multi-tier data warehouse strategy for what type of projects it is implemented.


  15. #15
    Junior Member
    Join Date
    Nov 2008
    Answers
    2

    Re: informatica

    Quote Originally Posted by manaskumarpatra View Post
    How manay types of transformation in informatica and what are they.

    There are more then 20 transformations in informatica
    Those are (source qualifier,filter,expression,aggregator,joiner,sequence generator,rank,sorter,stored procedure,lookup,union,router,update strategy,transaction control)


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