Answered Questions

  • Loading data to multiple targets

    how to create mapping that half records will go to one target and half to another target?

    sivakp

    • Mar 13th, 2011

    Create two source qualifier write a query in SQL override select * from emp where rownum in(select count(*)/2 from emp)another
    SQL override write a queryselect * from empminusselect * from emp where rownum in(select count(*)/2 from emp)
    To connect target

  • Aggregator

    Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

    KOTI

    • Oct 31st, 2011

    First find out the problem whether it is due to aggregator transformation or not. Run debugging...

  • What are 2 modes of data movement in Informatica Server?

    The data movement mode depends on whether Informatica Server should process single byte or multi-byte character data. This mode selection can affect the enforcement of code page relationships and code page validation in the Informatica Client and Server.a) Unicode - IS allows 2 bytes for each character and uses additional byte for each non-ascii character (such as Japanese characters)b) ASCII - IS...

    Star Read Best Answer

    Editorial / Best Answer

    Answered by: purushotham

    • Aug 9th, 2005


    the two types of modes are: 
    1) Normal Mode in which for every record a separate DML stmt will be prepared and executed 
     
    Bulk Mode in which for multiple records DML stmt will be preapred and executed thus improves performance.

    amolrenose

    • Sep 18th, 2011

    Data Movement Modes

    1. ASCII mode :- Single byte of data is processed.
    2. UNICODE mode :- Two bytes of data is processed.

    Data Loading Modes

    1. Normal Mode :- Commit is executed after 10000 records (default).
    2. Bulk Mode :- Commit is executed after all records have been loaded.

  • What are Aggregate transformation?

    Aggregator transformation allows you to perform aggregate calculations, such as averages and sums.

    Star Read Best Answer

    Editorial / Best Answer

    Answered by: Praveen vasudev

    • Sep 12th, 2005


    Aggregator transform is m uch like the Group by clause in traditional SQL.

    this particular transform is a connected/active transform which can take the incoming data form the mapping pipeline and group them based on the group by ports specified and can caculated aggregate funtions like ( avg, sum, count, stddev....e.tc) for each of those groups.

    From a performanace perspective if your mapping has an AGGREGATOR transform use filters and sorters very early in the pipeline if there is any need for them.

    veepee

    sivakp

    • Mar 13th, 2011

    1. Aggrigator transformation allows to perform aggrigate calculation, such as SUM, MAX, MIN, FIRST, LAST2. Aggrigator transformation allows to perform aggrigate calculation of group.

    shr_4

    • Oct 27th, 2010

    To perform Group by calculations  we use Aggregator Transformation.It perform calculations similar to Expression Transformation.But difference  between both is that Aggregator Transform...

  • How you will avoid duplicating records in a query?

    By using DISTINCT