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

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

1 Answers  

---

what is diff between IN and EXIT commands

1 Answers   HCL, Schneider,

---

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  

---

What do you mean by enterprise data warehousing?

0 Answers  

---

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

11 Answers   Deloitte, IBM, iGate,

---

what is the method of error handling when session is running?

1 Answers   TCS,

---

What is the Difference between sorter and aggregator?

2 Answers  

---

What are the scheduling options to run a sesion?

2 Answers  

---

What are different types of transformations available in informatica?

0 Answers  

---

What is a transaction control transformation?

0 Answers   Informatica,

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,

---

What is the capacity of power cube?

1 Answers  

---