Informatica Interview Questions, exit interview questions.#Exit #interview #questions


exit interview questions

Transformation to Load 5 Flat files

What is the method of loading 5 flat files of having same structure to a single target and which transformations will you use?

  • PreSQL in source qualifier and preSQL in target in Informatica
  • PreSql in Source Qualifier and PreSQL in Target in Informatica

    I am not able to understand the different between PreSql in Source Qualifier and PreSQL in Target in Informatica. I read many other posts they told pre SQL means ” SQL statement executed using the source connection,before a pipeline is run” and post SQL means ” SQL statement executed using the source connection,after a pipeline is run”. So if all PRESQL run at same point so why we have different PRESQL like PreSQL in SOurce qualifier and PreSQL in Target

  • Create session log as a parameter in Informatica cloud
  • Create Session log as a Parameter in Informatica Cloud

    How to create a session log as a parameter in informatica cloud?

  • What are the daily routines of an Informatica developer?
  • what are the daily routines of an informatica developer?

    If I have a source as below:

    Employeed, FamilyId, Contribution

    And my desired target is as below:

    Explanation: The contribution field in target is the individual Employee’s share in a family’s contribution.Say if total family contribution is 40000 then if A has contributed 10000 then target should have a value of 25%.

    Can you please suggest me an approach to solve the specified problem?

    pivoting of the records

    source: target: col1 col2 col1 col2 a 1 1 a,b,c,d b 1 2 p,q,r c 1 3 x d 1 p 2 q 2 r 2 x 3 how to do this. Thanks, krishna.

  • What are the types of loading in Informatica?
  • What are the types of loading in Informatica?

  • Filter, sorter, joiner transformations and source qualifier
  • Filter, Sorter, Joiner Transformations and Source Qualifier

    Why do we need transformations like filter, sorter, Joiner etc when we can do all those tasks with Source Qualifier itself using queries?

  • What is rank transformation?Where can we use this transformation?
  • what is rank transformation?where can we use this transformation?

  • How to remove footer from flat file source
  • How to remove footer from flat file source

  • Flat file as source in Informatica
  • Flat File as Source in Informatica

    How can we receive source as flat file in informatica, from where we get this flat file?

    Is it possible to use SCD Type-2 without using Lookup in the mapping?If it is possible please let me know. How it will be possible?

  • Add/modify column changes in facts and dimensions
  • Add/Modify Column Changes in Facts and Dimensions

    How often do you get Add/modify column changes in Facts and dimensions? Could you please give me couple real time Datawarehouse Project specific (Day to day work) scenarios?

    Execute Workflows Conditionally

    I have 2 workflows named as W1 and W2 so I need to execute W2 but after W1 workflow executed successfully then only executed W2 workflow? How to do this one?

  • How many types of sessions are there in Informatica.Please explain.
  • how many types of sessions are there in informatica.please explain them.

  • What is use of UNIX in Informatica?
  • What is use of UNIX in Informatica?

    What is use of UNIX in Informatica? Where and how can we use UNIX shell scripts or commands to run informatica jobs or other related applications in informatica?

  • Why cant we use a sequence generator or update strategy transformation.
  • Why cant we use a sequence generator or update strategy transformation before a joiner or union transformation?

  • Informatica high availability check
  • Informatica High Availability check

    How to check if the Informatica Power Center is highly available?

  • What is the default join that source qualifier provides?
  • What is the default join that source qualifier provides?

    Inner equi join.

  • Check manual entries in target table
  • Check Manual Entries in Target Table

    I am loading records from a source table to a CRM target table. I want to get the details of the manually inserted, updated, deleted records from the target table. Please explain in detail.


  • About Author:

    Leave A Comment

    Your email address will not be published. Required fields are marked *