Answer / nitish kumar

reject loader is informtica utility which is used to load rejected rows to the target with some specific condition.

What are ETL Tools?

0 Answers   Informatica,

---

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,

---

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 Answers  

---

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 Answers  

---

What is joiner transformation in informatica?

0 Answers  

---

can you please explain me pre session and post session options?

3 Answers   BTBP,

---

What is the Process to creating lookup transformation in informatica

0 Answers   Informatica,

---

What is the difference between router and filter?

0 Answers  

---

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

---

Global and Local shortcuts. Advantages.

0 Answers  

---

suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?

9 Answers   IBM,

---

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,

---