Answer Posted / ankit kansal

Incremental Aggregation ->

Incremental Aggregation is a technique to populate data on your aggregated tables or materialized view incrementally.

It takes new incoming data only based upon last updated column value or created_date time stamp column and thus uses its own cache created/updated earlier and updated the table as required.

http://deepinopensource.blogspot.in/

How can we use mapping variables in informatica? Where do we use them?

1200

---

Explain target update override in informatica

1126

---

Different sorts of metadata that stores in the storage facility?

1011

---

What is complex mapping?

1120

---

Is there any target staging area in informatica not staging area

2578

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2057

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2121

---

How to extract the informatica rejected data?

1220

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2356

---

What is joiner transformation?

1010

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2518

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1075

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1641

---

How would you join a node to the already existing domain?

1130

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2182

---