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 lookup transformation is active in informatica

1150

---

Which development components of informatica have the highest usage?

1099

---

What are the limitations of joiner transformation?

1180

---

What is the difference between Active and Passive transformation?

1224

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1848

---

What is olap (on-line analytical processing?

1112

---

What are the different ways to implement parallel processing in informatica?

1483

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1733

---

what is the complex transformation you used in informatica

2624

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1339

---

Differentiate between sessions and batches?

1070

---

can u give example for factless fact table

6783

---

What are the different options available for update strategy?

1054

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1559

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1207

---