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

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,

---

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

4 Answers   Magna Infotech,

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

0 Answers  

---

Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 Answers  

---

What is the benefit of session partitioning?

0 Answers  

---

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,

---

Using Expression transformation how to remove duplicate records from a relational source?

4 Answers  

---

what is data driven?

5 Answers   TCS, Wipro,

---

Why do we use DSS database for OLAP tools?

2 Answers  

---

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

---

What is diff joiner and lookup

4 Answers   BirlaSoft,

---