Answer / sayan

yes we can use bulk load if we are using static lookup.
condition: 1. we are not using a dynamic lookup on the target table. 2. There is no duplicate in the record in the data.

hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,

---

How to do the error handling of if ur source is flatfiles?

0 Answers  

---

What are the limitations of joiner transformation?

0 Answers   Informatica,

---

Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers  

---

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

---

Explain pmcmd command usage in informatica

0 Answers   Informatica,

---

What are the types of groups in Router transformation?

1 Answers   Informatica,

---

If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,

---

what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,

---

Explain the mapping variable usage example in informatica

0 Answers   Informatica,

---

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

5 Answers   TCS,

---

When the informatica server marks that a batch is failed?

1 Answers  

---