Answer / swetha

For a relational sources informatica server creates multiple
connections for each parttion of a single source and
extracts seperate range of data for each connection.
Informatica server reads multiple partitions of a single
source concurently. Similarly for loading also informatica
server creates multiple connections to the target and loads
partitions of data concurently.

For XML and file sources,informatica server reads multiple
files concurently. For loading the data informatica server
creates a seperate file for each partition(of a source
file).U can choose to merge the targets.

What is persistent lookup cache?

0 Answers  

---

What is operational data source (ODS)?

7 Answers  

---

Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 Answers  

---

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  

---

When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 Answers  

---

My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...

2 Answers   Accenture,

---

What is a passive transformation?

0 Answers   Informatica,

---

What are junk dimensions?

0 Answers  

---

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  

---

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,

---

Roles and Responsibilties of Informatica Production Support Member?

6 Answers  

---

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

2 Answers   TCS,

---