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

How to load duplicate records in to a target table which has a primary key?

2 Answers  

---

In target table how to display the system time

1 Answers  

---

In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data

2 Answers   HCL, Schneider,

---

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,

---

Is it possible to create multiple domains on a single Informatica server?

1 Answers  

---

What is the difference between view and materialised view?

6 Answers  

---

What if the source is a flat-file?

1 Answers  

---

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1 Answers   IBM,

---

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers   Oracle,

---

What is staging area?

11 Answers  

---

How informatica process data means how informatica works?

2 Answers   TCS,

---