HOW DO YOU PARFORM INCREMENTAL LAOD ?
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 will be the approach?
How do you load first and last records into target table?
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
How to run a session, which contains mapplet?
1 lac of flat fles in source how to load target at a time?
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
What is the use of incremental aggregation?
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
can v update d records in target using update stargey without generationg primary key ? explain
i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....