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)

i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,

what is data driven?

5 Answers   TCS, Wipro,

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,

Repository user profiles

0 Answers  

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

0 Answers  

I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,

As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?

2 Answers  

How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,

star and snowflake schema?

6 Answers  

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,

How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

2 Answers   IBM,