Answer / aa

Place the xml template in the MappingTemplate folder in ur C drive

u can refer more info below as well as Informatica KB

https://etltechsolutions.wordpress.com/2016/02/09/informatica-visio-table-definition-not-found-exception-error/

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

0 Answers   HP,

---

Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

---

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

---

What is the sql query overwrite in source qualifier in informatica

0 Answers   Informatica,

---

Explain the etl program with few examples.

0 Answers  

---

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  

---

Explain the use of aggregator cache file?

0 Answers  

---

what is the difference between static and dynamic

4 Answers   TCS, Wipro,

---

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

6 Answers   Accenture,

---

How to do unit testing in informatica? How to load data in informatica ?

0 Answers  

---

How do you handle two sessions in Informatica

0 Answers   Informatica,

---

what is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,

---