Answer / mahipal reddy

first create a sequence to those 10 records n using filter
or router transformation filter first 5 columns n load into
target similarly remianing 5 records.

Answer / gazulas

what if the number 10 changes??

use a sql transfermation and get the record count or use an agg get rec count and pass it into record_count. use seq gen and populate the numbers. then use a router and write condition seq no <= record_count/2 -- target1

default to target 2.

this will work even ur records changes to 100 or 25o or 40000..etc

Useful UNIX commands regular/frequently used

1 Answers   Deloitte,

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

0 Answers   Puma,

---

i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?

3 Answers   IBM,

---

How i can upload the MainFrame source For Informatica ?

1 Answers  

---

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  

---

---

what we require for D.modelling?

1 Answers  

---

what is datamart

4 Answers   IBM, Informatica,

---

how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy

2 Answers  

---

How can we eliminate duplicate rows from flatfile,explain?

3 Answers  

---

Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)

1 Answers  

---

difference between informatica 8.6 and 9

3 Answers   Atos Origin, BA Continnum Solutions, Core Logic,

---

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

---