Answer / kumar

replacestr function won't work for characters larger than 65535.

https://etltechsolutions.wordpress.com/2016/05/11/error-message-is-replacestr-data-too-large/

and

https://network.informatica.com/thread/3080

What are the tasks that source qualifier performs?

1 Answers  

---

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,

---

What do you understand by term role-playing dimension?

0 Answers  

---

What is the procedure to load the fact table.Give in detail?

1 Answers  

---

what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

3 Answers   IBM, ITC Infotech,

---

---

What do you understand by SOA of Informatica?

0 Answers  

---

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

2 Answers   TCS,

---

Different qualification between a related rotate toward the sky and isolates look upward?

0 Answers  

---

What all are steps in up gradation of Informatica server?

0 Answers  

---

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,

---

what is difference between dimention table and fact table?

1 Answers  

---

Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  

---