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

Can you start a session inside a batch individually?

2 Answers  

---

how to load duplicate row in a target

4 Answers  

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.

1 Answers   DELL,

---

How an expression transformation differs from aggregator transformation?

0 Answers  

---

What is the format of informatica objects in a repository?

0 Answers  

---

what is the difference between copy object import objects using repositery manager which one is best

1 Answers   TCS,

---

What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,

---

how many repositories can v create in informatica .

3 Answers   Cap Gemini, Tech Mahindra,

---

Explain the features of connected and unconnected lookup.

0 Answers  

---

what is casual dimension?

6 Answers   IBM,

---

How many repositories can be created in informatica?

1 Answers  

---

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,

---