• Home
  • rajesh_kare Answers

Answered Questions

  • Feb 25 2008
    02:33 AM
    4936
    21

    Target Details Verification
    • sarun5

    If the records are transfered from Source to target and if you want to check whether all the records are stored in the target. What are the possible ways to check that.

    Rishak

    • May 21st, 2012

    If you want to check the records,you can directly use MINUS query for eg 

    Code
    1.  SELECT  count(*) FROM source
      2. 

    2. minus
      3. 

    3. SELECT count(*) FROM target
      4. 

    4.  
      5. 

    5.  
    Hope this will help Thanks Risha

  • Feb 18 2008
    09:00 PM
    30927
    33

    Joiner Transformation Master Detail
    • sarun5

    Suppose you have 2000 records in one table and 12000 in another which one you will consider as master and detail?

    Star Read Best Answer

    Editorial / Best Answer

    ghola  

    • Member Since Jul-2008 | Aug 15th, 2008

    The joiner transformation compares each row of the master source against the detail source. Hence, fewer number of rows in master means fewer iterations of join comparison.

    Secondly It is easier to cache the table with fewer number of rows.

    Hence, using the table having the fewer number of rows as a master improves the performance.

    Raju R

    • Oct 27th, 2015

    @ponnana: The performance of the joiner depends on the rows and not on the columns. Also you take up the condition which consists n number of columns. Based on the condition the rows are obtained. So We need not worry about the columns.

    Rashmi

    • Oct 18th, 2015

    The join is happening based on some condition. Therefore match process depends on the condition columns only and not how many columns are present in total. The table you drag into joiner first is considered as Master.

  • Mar 27 2006
    07:25 PM
    13416
    10

    Partitions in Informatica
    • Arpita

    Can anyone explain all the 4 partitions in Informatica and on which table what partition is used?2.Suppose we have 4 columns in a table primary key, 2 string columns and a numeric column? While doing a group by aggregation. what is the order that we have to group by?Thanks,Arpita.

    Kevin

    • Jul 19th, 2023

    Database partitioning. The PowerCenter Integration Service queries the IBM DB2 or Oracle system for table partition information. It reads partitioned data from the corresponding nodes in the database....