Answer / chiky

How does one do incremnental loading

CHECK OUT THE OPTION, truncate target table option in
sesson==> target properties.
this makes the incremental load.

Scenario - You are trying to load reasonable amount of
rows into the target table, and its taking a helluva lot of
time.What could be the reasons?
use bulk loading in session properties.
use less record as master table in joiner
use filter in first of the mappings
dont use unwanted columns in source qualifier.. better use
SQL overriding.
use dynamic lookup only if in use.
tune your query what ever reads from db.
use partitioning of table if records are huge in number.


3.Tell me any complex situation you have faced( as an
Informatica Developer) and how did you resolve it.
4.tell me any complex mapping that you have done.
AM not enough experienced to answer this two questions.

Answer / abhinaw prakash

Answer
1.We can do incremental loading by clicking on the check box inside Aggrgator T/R.Use filter transformation before Aggrgator to filter out rows and pass only the changed records to the flow.
2.One of the reasons could be the time its taking to build caches.to answer this more details of the maping is required.

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,

---

Write the unconnected lookup syntax and how to return more than one column.

0 Answers  

---

differences between service based and product based?

0 Answers   Satyam,

---

How to handle decimal places while importing a flatfile into informatica?

0 Answers  

---

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,

---

---

What are the different caches used in informatica?

3 Answers   UST,

---

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  

---

Scheduling properties,whats the default (sequential)

0 Answers  

---

What does role playing dimension mean?

0 Answers  

---

how to obtain performance data for individual transformations.

2 Answers  

---

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

---

"Change cache" in Informatica ?

2 Answers  

---