Answer Posted / masudul

Create a two flow mapping.
First Flow-

1.take the original source
2.inside Source qualifier write down the query

select * from (select * from tabl_name) where rownum <=(select count(key_column_name) from tabl_name)/2 );

then dump it to the target. this will take the first half of the entire source.

and in second Flow do the reverse thing..

Global and Local shortcuts. Advantages.

1953

---

Can anyone tell me the new features in Informatica 9 Version?

2030

---

What are the new features of informatica 9.x developer?

899

---

What is target load order?

1184

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2020

---

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

1048

---

What is the Process to creating lookup transformation in informatica

980

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1985

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1028

---

Write the unconnected lookup syntax?

1029

---

What is the need of an ETL tool?

1025

---

What is a surrogate key?

1014

---

What can we do to improve the performance of informatica aggregator transformation?

1041

---

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

1047

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

988

---