Answer / mahi

It will take all the records form detailed table,
and matching records form master table.

Answer / jay

For eg.

Select M.*, D.* from
Master M LEFT OUTER JOIN Details D
on M.ID = D.ID

In the above query we get all the records from Master table and matching records from Detail table.

In simple it takes all rows from the table which is left of the join and matching records from table which is in other side of the join.

Answer / rashid equbal

It will take all the records form detailed table,
and matching records from master table.

What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

2 Answers   IBM, Wipro,

---

what are cost based and rule based approaches and what is the difference?

1 Answers  

---

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

---

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

Which transformation should u need while using the cobol sources as source defintions?

2 Answers  

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

0 Answers   IBM, TCS,

---

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,

---

where is the reject loader .

1 Answers  

---

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers  

---

how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,

---

i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?

3 Answers   IBM,

---

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,

---