Answer / pooja

In hash partitioning, the Informatica Server uses a hash function to group rows of data among partitions. The Informatica Server groups the data based on a partition key. Use hash partitioning when you want the Informatica Server to distribute rows to the partitions by group

What are the two modes of datamovement in informatica sever?

2 Answers  

---

I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,

---

What is workflow? What are the components of workflow manager?

0 Answers  

---

How do you implement unconn. Stored proc. In a mapping?

1 Answers  

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

0 Answers  

---

Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,

---

What are junk dimensions?

0 Answers  

---

Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 Answers  

---

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,

---

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 Answers  

---

what is hash table in informatica?

1 Answers   Zensar,

---

What are reusable transformations in how many ways we can create them?

2 Answers  

---