Answer / arpita

Normal Mode and Bulk Mode

Why we use ENABLE HIGH PRECISION in session properties?

2 Answers   Cognizant,

---

without update strategy how to insert &update?

1 Answers   DELL,

---

What is fact table? Explain the different kinds of facts.

0 Answers  

---

what is the look up transformation?

2 Answers   Informatica,

---

how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,

---

---

difference between shortcut and reusable transformation?

2 Answers  

---

What is the Hierarchy of DWH?

1 Answers  

---

what is Partitioning ? where we can use Partition?

2 Answers   IBM, TCS,

---

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,

---

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6 Answers   IBM,

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

0 Answers  

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

---