Answer Posted / sujatha

Hi,
First declare mapping variable like $$rec_load in mapping tab under parameters/variables.

next in expression transformation declare one port like rec_count=setvariable($$rec_load,$$rec_load+1000)

first time $$rec_load having value zero.next time it will load 1000 records like that every run it will increment 1000 records.

Can we override a native sql query within informatica?

1036

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2261

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1109

---

How are the sources and targets definitions imported in informatica designer?

1107

---

What is primary and backup node?

1127

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2518

---

What is decode in informatica?

1162

---

What is an aggregator transformation?

1096

---

Differences between connected and unconnected lookup?

1218

---

What is a mapplet/worklet in informatica?

1188

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6490

---

What is the sequence generator transformation in informatica?

1184

---

How to use procedural logic inside infromatica?

1236

---

What are the various types of transformation?

1179

---

draw informatica architecture 8.6 ?

3871

---