Hi Friends,
We are working on Informatica to Datastage Migration project. One of the job which we have developed is giving issue. All the mappings and transformations are same as Informatica mappings and logics. But the record count in the target differs. For Example, Informatica is loading 2 records whereas Datastage is loading 5 records in the target.
We found one difference in Informatica behavior and Datastage behavior.
For example : In Datastage, INNER JOIN will process all the multiple matched records whereas in Informatica INNER JOIN will process only one of the multiple matched records.
Table A :
Emp_Name Emp_No Arun 257816 Arun 257644
Arun 269812
Table B :
Emp_Name
Arun
Join Condition : A.Emp_Name = B.Emp_Name
Datastage Join Stage populates all the 3 records but Informatica Join Stage populate only one of those 3 records.
Do you know any other architectural behavior differences between Informatica & Datastage ?
Informatica to Datastage Migration Checklist
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Inner join works alike in Informatica and Datastage.
Hi Synsog,
Inner join will work the same way it works in Datastage. Can you please check the constraints in the informatica stage, which you have used. It should retrieve all the matched three rows. There are no difference between inner join in Datastage and Informatica.
Inner join will work the same way it works in Datastage. Can you please check the constraints in the informatica stage, which you have used. It should retrieve all the matched three rows. There are no difference between inner join in Datastage and Informatica.
-
- Participant
- Posts: 7
- Joined: Thu May 24, 2012 12:55 pm
- Contact:
checklist
i have posted one that was used in an earlier project. let me know if it can be improved in anyway
http://ds.iexpertify.com/2013/09/datast ... klist.html
http://ds.iexpertify.com/2013/09/datast ... klist.html