Answer Posted / somnath pain

I suppose u r working with informatica.
So here u can import the source and after the source use a
expression transformation.
use a sq generator set start val to 1.
connect the nextval port to expession transformation.
apply a filter and set filter condition as nextval=1 connect
the filter o/p to target.
u will get the desired row.

regards,
Somnath

What is domain and gateway node?

1119

---

What are the designer tools for creating transformations?

1046

---

How can informatica be used for an organization?

1130

---

What is union transformation?

906

---

What are the different transaction levels available in transaction control transformation?

1118

---

What is a filter transformation and why it is an active one?

905

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

950

---

How can a transformation be made reusable?

1077

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2094

---

Sequence generator, when you move from develoment to production how will you reset

1940

---

Why do you use Mapping Parameter and mapping variable?

1678

---

How are indexes created after completing the load process?

1544

---

How to extract the informatica rejected data?

1162

---

How can one identify whether mapping is correct or not without connecting session?

1368

---

What is session task and command task?

1176

---