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
- 22149 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 |
which quality process u can approach in ur project
How do you change parameter when you move it from development to production.
How to elaborate powercenter integration service?
State the differences between sql override and lookup override?
If u select groupby port in aggregator what is output and dont select groupby option what is output
difference between informatica 8.1.1 and 8.6
What is junk dimention?
without table how to come first record only in oracle?
How to join three sources using joiner? Explain though mapping flow.
what is index?how it can work in informatica
i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...
Label in Informatica. How to remove existing Label.
Teradata 
