Answer / natraj

Hii Eswar can you please explain elaborately.....
thank you

Answer / nataraj

Hi sanajy.. thanks for ur reply... i dont want to load the
records into different files.... i need to load the same
file in different mapping runs...

Than you

Answer / muddam

First declare variable paramater as las_extract_date and
create port as last_updated_date and connect source.qf
transforamtion override, give as where
last_ext_dt>=last_update_date with time stamp it will work
out.

Answer / sujatha

Hi,
First declare mapping variable like $$rec_load in mapping tab under parameters/variables.

next in expression transformation declare one port like rec_count=setvariable($$rec_load,$$rec_load+1000)

first time $$rec_load having value zero.next time it will load 1000 records like that every run it will increment 1000 records.

Answer / remesh

BY USING INCREMENTAL LOADING CONCEPT

GO TO SESSION PROPERTIES--->

IN THAT U FIND OPTIONS INITIAL VALUUE AND INCREMENT VALUE
IN THAT U CAN INITIALIZE THE VALUES

Answer / ganesh

First declare variable parameters start value =0 and end
value=1000. Then, connect sour > seq > filter > target.
assign the seq start value = start value and end value = end
value. it will pass first 1000 records. next time increment
the variable parameter by 1000 for both start and end value.
then, it will send the next 2000 records. then, do the same
process for the remaining.

Answer / praveen

You can use override query in the source qualifier and set it to read rownum <= 10000. This will load the first, similar way you can do the remaining.

Answer / praveen hattikal

src---->sq---->exp1--->filter---->exp2---->tgt
sequence gen---^

create mapping variable $run=1000/ in exp2 $run=$run+1000

in filter sequence <$run

Answer / kish

Hi,

you can go for partitioning... i dont know exactly the
procedure...but this the way wat i know..... if there is any
clear explanation...it will be great...

Answer / eswar

it is change data capture(CDC)

Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 Answers  

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 Answers  

How many repositories can be created in informatica?

1 Answers  

How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,

What is the difference between lookup override and souce qualifier override ?

2 Answers   Puma,

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,

Can we create two repositories on same database instance in oracle?

0 Answers  

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  

In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,