Answer / sehaj

Incremental aggregation is nothing but a method of maintaing
new records in the target when we use an aggregator in our
mapping..
With incremental aggregation only those records which are
new in the source are processed in the mapping excluding
those which have been processed.
The data which was earlier present in the source n has been
processed is stored in the cache and the new records are
processed along with them.
For this we need to select the option INCREMENTAL
AGGREGATION from session properties.

Answer / naveen kumar

Before doing incremental aggregation u need to know incremental load, source data should be loaded incrementally, place a aggregator transformation group the ports on your requirement,like sales date then write your aggregate functions like max, min, sum, avg etc.. then check the property of incremental aggregation in session make sure the target table should have a primary key if it is relational then run the workflow... then u get the inital values pass a new record to the source and run the workflow.

Differentiate between Load Manager and DTM?

0 Answers  

---

What is meta data and system catalog?

2 Answers  

---

If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

3 Answers   IBM, TCS,

---

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,

---

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

---

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

---

What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,

---

Is there any model difference between ODS and DWH

2 Answers   Zensar,

---

What do think which one is the better joiner or look up?

0 Answers  

---

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,

---

how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,

---

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

---