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
- 22171 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 |
What are the designer tools for creating transformations?
What is meant by incremental aggregation?
In target table how to display the system time
What is meant by lookup transformation?
What is IQD file?
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How to open an older version of an object in the workspace?
Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga
Teradata 
