Answer / pooja

hi,

please get clear picture on the Question...
1. wherther all 3 source are in same schma or in differt
schme ..
if its in differnt schma means use joiner
if its same schma means u cn override the SQ query
2. if no.of columne and datatype are same for all the 3
source means you can use union trans....

Answer / madhu

we can use sourcequalifier transformation
or union transformation to combine different source to a
single source

Answer / rkumar.etl

use union transformation or you can write sql override if
you have advance knowledge of table join conditions for the
current database.

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---

Define Incremental Aggregation?

2 Answers  

---

major difference between normal loading and bulk loading?

6 Answers  

---

Can we use the mapping parameters or variables created in one mapping into another mapping?

1 Answers   Informatica,

---

What is a taget load order?

2 Answers   IBM,

---

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,

---

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,

---

What is complex mapping?

0 Answers  

---

how to call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,

---

in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,

---

How to list Top 10 salary, without using Rank Transmission?

16 Answers   Infosys,

---

What is main use of mapplet?

0 Answers  

---