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
- 26129 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 |
where does the default group roew in a router is stored what is the default size of memory in router
Define error Threshold?
How the dimensions will be loaded?
I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?
Separate from a database, an information bazaar, and an information stockroom?
Could you explain what is enterprise data warehouse?
what is the hint? how to use it to reduce the query processing in program?
What are the new features of the server manager in the informatica 5.0?
what type of problem you faced insales project or insurance project
how can one eliminate dupliacte data with out using distinct option?
why we use stored procedure transformation?
How can yoU create or import flat file definition in to the warehouse designer?
Teradata 
