Answer / swetha

yoU can join hetrogenious data sources in joiner
transformation which we can not achieve in source qualifier
transformation. yoU need matching keys to join two
relational sources in source qualifier transformation. Where
as you doesn't need matching keys to join two sources. Two
relational sources should come from same datasource in
source qualifier. yoU can join relatinal sources which aer
coming from different sources also.

Answer / david

One important thing is

IN source Qualifier 1)the columns used in the condition must
have primary-key and foreign-key relationship(Compulsory)
For example
If the condition is
Emp.deptno = dept.deptno1
The depeno and deptno1 should have primary and foreign
key relation

2)The datatypes of the couumns must be same

What is union transformation in informatica?

0 Answers  

---

What is difference macros and prompts?

2 Answers  

---

Two Default User groups created in the repository are ____ and ______

2 Answers  

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

0 Answers  

---

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,

---

How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,

---

What are the informatica performance improvement tips

0 Answers   Informatica,

---

How can yoU create or import flat file definition in to the warehouse designer?

2 Answers  

---

What are the disadvantages of Sequence Generator T/R?

3 Answers   Zensar,

---

What are session parameters ? How do you set them?

0 Answers  

---

What is data transformation manager process?

0 Answers  

---

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,

---