Answer / anu

IF 2 SOURCES ARE RELATIONAL USE SQ T/R
WRITE MANUVAL QUERY
first connect requrired 16+1 attributes to furter t/r or target
select required columns and in where condition write matched condition

if there is no common column go to joiner create sequence in both sources then compare sequence in join vondition

Answer / muni

take B table as master....A table as a detail.... so we can reduce serch process in joiner
than based on which column we are going to do join create a index on it

i hope it will give gud per'mance
if i i am worng plz create it

What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 Answers  

---

scd methodology?

2 Answers  

---

Can anyone tell me the new features in Informatica 9 Version?

2 Answers   Syntel,

---

What is the difference between informatica 8.x and 9.x

1 Answers   Wipro,

---

How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

2 Answers   AHM,

---

How to go to the older version for a mapping?

0 Answers  

---

What is the use of target designer?

0 Answers  

---

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,

---

How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,

---

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,

---

Differnce between filter and router?

14 Answers   IBM,

---

How to recover the standalone session?

2 Answers  

---