-
Loading data to multiple targets
how to create mapping that half records will go to one target and half to another target?
vijayant.sanjay
- Sep 7th, 2011
Use the sql override in source qualifier as select col1, col2, (select count(*) from table) from table;
In the mapping flag the rows into groups in router t/f as count(*) port count(*)/2sivakp
- 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...
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.
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
kethinenisarath
- Apr 9th, 2011
Hi! I think its best option to avoid duplicating records in a queryselect * from empwhere sal in ( select sal from emp &nbs...
