Answer / swetha

When a Joiner transformation occurs in a session, the
Informatica Server reads all the records from the master
source and builds index and data caches based on the master
rows.After building the caches, the Joiner transformation
reads records from the detail source and perform joins.

Answer / atiric sofrware(raja)

joiner caches are data cache and index cache data cache.

data cache that holds the master table rows and the index
cache which holds the join columns from the master table

Answer / soujanya

the joiner transformation creates join cache for master
source. from joiner cache the the joiner transformation
compares with detail source.
the joiner cache always uses master source for better
performance bcoz master source has less no. of records.
cache is the temporary memory

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc

3 Answers   HP,

---

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

6 Answers   TCS,

---

There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)

4 Answers  

---

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,

---

explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,

---

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

---

what is lookupoverriding?

1 Answers  

---

2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?

2 Answers   Emphasis,

---

If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   TCS,

---

How informatica process data means how informatica works?

2 Answers   TCS,

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

0 Answers  

---