Answer / balaswamy

because all rows from the master table are loaded into the cache,so that it will take up the least amount of space in the
cache

Answer / ankit kansal

Its preferable to create your smaller table to be master because
1.Size issue Informatica will create index and data cache.
2.More logical lets say your master table contains 10 rows and your detailed table contains 1000 rows so each of your source rows just have to check against 10 of master rows and thus its faster wile if you take it viceversa than each of your source table hast to go against 1000 rows and it ll hot performance issue This is just a small example check with real scenario and you ll came to know.

http://deepinopensource.blogspot.in/

Answer / voma

faster perfomance of loading

Answer / moorthy g

The Integration Service(IS) reads data from master table
and build data cahe and data index for building cache.
After that read data from detail table perform joins. bcz
routine will be very less(master means very less record
compared to detail table).
Finaly time saving. performance incresing.

explain about lookup t/r?

1 Answers   IBM,

---

Enlist few areas or real-time situations where informatica is required.

0 Answers  

---

hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,

---

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,

---

What is log file,and where is it located,why u r using the log file

1 Answers   TCS,

---

Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,

---

What is the difference between Bulk Load and Normal Load

3 Answers   TCS,

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

0 Answers   TCS, Wipro,

---

What is batch and describe about types of batches?

2 Answers  

---

In development project what is the process to follow for an etl developer from day1

0 Answers  

---

what is unit testing?tell me proceedure

0 Answers   L&T, UST,

---

Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve

15 Answers   TCS,

---