Answer / swetha

Master thread: Creates and manages all other threads

Maping thread: One maping thread will be creates for each
session.Fectchs session and maping information.

Pre and post session threads: This will be created to
perform pre and post session operations.

Reader thread: One thread will be created for each partition
of a source.It reads data from source.

Writer thread: It will be created to load data to the target.

Transformation thread: It will be created to tranform data.

If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

3 Answers   Amdocs,

---

How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?

3 Answers  

---

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers   HeadStrong, TCS,

---

What is different between the data warehouse and data mart?

0 Answers  

---

How You Pull the records on daily basis into your ETL Server.

2 Answers   TCS,

---

How might one distinguish in the case of mapping is right or not without associating session?

0 Answers  

---

what is Partitioning ? where we can use Partition?

2 Answers   IBM, TCS,

---

In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?

1 Answers   TCS,

---

i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

1 Answers   Mind Tree,

---

My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,

---

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

---

what is degenerated dimension table with scenario

2 Answers   HCL,

---