HOW DO YOU PARFORM INCREMENTAL LAOD ?
- 7 Answers
- 17183 Views
- SAIC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / subbu
by using the date coll in the source we do incremental load,
specifying the start date in source qualifier,changing the
start date in parameter file in future.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / praveen
Taking the Target defination as source and using the joiner
and update we can do the incremental loading
2.By using lookup transformation, keeping lookup on target
and companring.
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / tshiwela
you can perform increamental load by using auxiliary
parameters.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / sudhakar
BY USING MAPPINING VARIABLES,FIRST DEFINE THE VARIABLE
E.DATE AND NEXT COMPARE E.DATE,IF IT MATCHES THEN DATA
AUTOMATICALLY LOADED.
| Is This Answer Correct ? | 0 Yes | 0 No |
By using the date column in the source we do incremental load,
specifying the start date in source qualifier,changing the
start date in parameter file in future.
With this in mind, I will expect a load pattern like this
Every extract from the source will be a full load
Every load in terms of records, will be equal to last load + new records – deleted records
80-90 % of the extracted records will already exist in the valid table instance
Every load will be incrementally larger than the previous load, as more records are added to the sourceThinking
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vaschiky
Disable truncate target table option from session target
table properties.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the use of target designer?
how will compare two mappings in two different repository?
What aer the out put files that the informatica server creates during the session running?
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
Issue with Update override at Target table in Informatica.
explain abt joiner t/r?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
how we do performence tuning in informatica
How to improve the session performance in informatica?
What is a node in Informatica?
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,
How to import oracle sequence into Informatica?
Teradata 
