Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose i have 10000 records.First time i have to load 1 to
1000 records and second run i have load 1000 to 2000
records and third load i have to load 2000 to 3000 rows .How
will achieve
- 15 Answers
- 26580 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
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.
| Is This Answer Correct ? | 1 Yes | 1 No |
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
| Is This Answer Correct ? | 0 Yes | 1 No |
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.
| Is This Answer Correct ? | 0 Yes | 1 No |
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.
| Is This Answer Correct ? | 0 Yes | 2 No |
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
| Is This Answer Correct ? | 0 Yes | 2 No |
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...
| Is This Answer Correct ? | 1 Yes | 4 No |
Plz can any one say me how to get the informatica certification materials and dumps
Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.
How to partition the Session?
What are the types of maping in Getting Started Wizard?
What does command task mean?
what are surrogate keys?
What are the tasks that Loadmanger process will do?
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
What are the databases that informatica can connect to windows?
What are the active and passive transforamtions?
How can a transformation be made reusable?
What is polling in informatica ?
Teradata 
