Answer / sravanthi

in session level go to the mapping tab set the load type is BULK so it reduce the loading time

Answer / sony_infa

use session partition to improve the performance.

Answer / venkateshmalneni

if we do the performance optimization we can achieve the task i think (ie we can reduce the time of loading the data into target)

if my answer is wrong please let me know the write answer

Answer / sony_infa

using session partition we can improve the performance.

Answer / subhransu panda

Using session partition we can reduce the time.
Because at a time the parallel pipeline created in session partition will process the incoming data ,by distributing the data in equal nos among the parallel pipelines.

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

what is mean by flag 4 in update strategy t/r

6 Answers  

Where do you create/define mapping parameter and mapping variable?

1 Answers  

What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,

What differs when we choose the sorted input for aggregator transformation?

0 Answers  

What is the sequence generator transformation in informatica?

0 Answers  

i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,

Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 Answers  

Whats the difference between $, $$, $$$

9 Answers  

what transformations are used for Variable port?

2 Answers