Answer / hari

create mapping like

source -- sorter -- expression -- filter -- target.

here sorter is used to send data by ascending order data
this is not mandatory.

Expression is need to create variable port which will count
the rows which are comming in.

Filter having condition like if count value >=51 and count
value <= 100.

Answer / venkateshmalneni

Generate sequence by using sequence generator or by using expression t/r
connect the output to the filter t/r in filter write the condition as sno>=51 and sno=100
connect it to the target

src--->sq---> expression--->filter--->target

Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve

15 Answers   TCS,

---

My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

1 Answers   TCS,

---

How will you update the row without using update statergy?

10 Answers   CTS,

---

How will you check the bottle necks in informatica? From where do you start checking?

3 Answers   HCL,

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,

---

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

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,

---

What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance

15 Answers   Deloitte,

---

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

3 Answers   Accenture, CSC,

---

How many mapplets u have created? and what is the logic used

5 Answers   Mind Tree,

---

How do you do error handling in Informatica?

1 Answers  

---

How can a transformation be made reusable?

0 Answers   Informatica,

---