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.

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,

---

What is the format of informatica objects in a repository?

0 Answers  

---

where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  

---

What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .

1 Answers  

---

how to run the batch using pmcmd command

2 Answers   Wipro,

---

What is use of batch file in informatica? How many types of batch file in informatica?

2 Answers   EXL,

---

HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  

---

suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer

1 Answers   TCS,

---

lookup transformation with screenshots

0 Answers   TCS,

---

can we use bulk loading when we use look in mapping

1 Answers   TCS,

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers   IBM,

---