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.

How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  

---

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,

---

How many repositories can we create in Informatica?

3 Answers  

---

What are multi-group transformations?

0 Answers   Informatica,

---

AT the max how many transformations and mapplets can we use in a mapping ?

1 Answers   Cap Gemini, Cognizant,

---

---

If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers  

---

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

---

Scenario:-  Below is the requirement. Source:-  NAME          ID                    Requirement  RAVI            1                      (no need to repeat as it ID is 1) KUMAR        3                     (repeat 3 times as it ID is 3) John             4                     (repeat 4 times as it ID is 4) Required Out Put:- Name                   ID RAVI                     1                    KUMAR                3      KUMAR                3 KUMAR                3  John                     4 John                     4 John                     4 John                     4 Scenario 2:- Source Data  ID              NAME 1,2            NETEZZA,ORACLE 3,4,5         SQL Server, DB2, Teradata Required Output:-  ID                   NAME 1                  NETEZZA 1                  ORACLE 3                  SQL Server 3                  DB2 3                  Teradata

1 Answers   Cognizant,

---

Which is the t/r that builts only single cache memory?

0 Answers  

---

disable caching in a lookup transformation?

1 Answers  

---

How do you implement unconn. Stored proc. In a mapping?

1 Answers  

---

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

---