In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,

---

What is the filename which you need to configure in UNIX while installing infromatica?

2 Answers   Accenture,

---

How to load only the first and last record of a flat file into the target?

3 Answers   Mind Tree,

---

By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

5 Answers   Keane India Ltd,

---

How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?

10 Answers   Wipro,

---

---

how we load the data from source to staging area

4 Answers   TCS,

---

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---

what is the difference between static and dynamic

4 Answers   TCS, Wipro,

---

Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.

7 Answers   Cognizant, Wipro,

---

How to recover the standalone session?

2 Answers  

---

I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance

4 Answers  

---

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,

---