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..

Explain what transformation and how many are there in informatica?

958

---

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2280

---

How many types of sessions are there in informatica.please explain them?

1169

---

What is the need for an etl tool?

1068

---

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

---

Briefly describe lookup transformation?

1046

---

How do you take back up of repository?

1162

---

How to create or import flat file definition in to the warehouse designer?

1070

---

generate date / time dimension in informatica

1125

---

Slowly changing dimensions, types and where will you use them

1713

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9827

---

What is rank transformation?

991

---

Describe the impact of several join conditions and join order in a joiner transformation?

1063

---

What is the cumulative sum and moving sum?

1186

---

What is blocking transformation?

1144

---