Answer / srinivas

Hi,qustion was not clear.

As per my understanding After join if we get 101 records in target, then we can say one duplicate was there in B table.
While joining the tables by using left outer total records from left table and matched records from both will be load into target.
so i will give small example

We have two tables A & B
A having

Id Name
1 sri
2 hari
3 prasad

B Having
LeavesId
1
1
2
3

If will do the left outer join u will get below

No name leavesid
1 sri 1
1 sri 1
2 hari 2
3 prasad 3.

As per above example may help u to demonstrate the your query.

Thanks
Sri

Answer / geetha

Extra 1 records  is populated in case of duplicate records in the reference tables. lets say we have emp_id A in left table and we have two emp_id A ,in this case we will have duplicate records in the output.

Answer / hirdesh srivastava

If you join two tables either equi join, left outer join or right outer join, result records can't be greater than max record of a big table. Until or unless you go for full outer join. e.g. if there are 100 records in one table and 20 records in other table then if you go for any join except full outer join result records won't be greater than 100 records. 

Explain the ChangeApply stage?

11 Answers  

---

whats relation between configuration file and datasets?

2 Answers   L&T, Wipro,

---

job locking methods? How can we unlock the job?

3 Answers   IBM,

---

Define Data Stage?

0 Answers  

---

What are the unit test cases you used in your project?

1 Answers   CSC, HY,

---

---

Have you have ever worked in unix environment and why it is useful in datastage?

0 Answers  

---

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..

1 Answers  

---

I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

1 Answers   Accenture,

---

what is set mapping in datastage??

2 Answers   ADP,

---

What is the function in Transformer stage can act as Rank Function in oracle

1 Answers   Reliance,

---

what r the stages mostly used in realtime scenarios

4 Answers   HCL, IBM,

---

Define ds designer?

0 Answers  

---