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.

What are the designer tools for creating tranformations?

1 Answers   Informatica,

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

---

Why we need XMLs?

3 Answers   IBM,

---

What is standalone command task?

0 Answers  

---

Explain the code page compatibility?

0 Answers  

---

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

---

.prm wirh repalce .txt is possible?

2 Answers  

---

What is difference between maplet and reusable transformation?

2 Answers  

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

0 Answers   Nationwide,

---

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,

---

what is the diff b/w target load plan and cbl?

3 Answers   CTS, iGate,

---

What is difference between partioning of relatonal target and partitioning of file targets?

2 Answers  

---