Say file has 1000 records and for all the records data is populated and Oracle table has match for all the records.
Then ran my mapping in verbise data mode and in the joinner i can see for 385 records store id is matching with orcla store id. Rest all the records are filtered out as the...
This file is fixed length file.
But my question is say the data file has blank store_ids, then they should be consistently blanks, but if i divide my file to 385 records the same data has not null value for store id.
Hi,
I am having a unique issue with loading a flat file to informatica. I am getting the data from flat file and oracle table and joining them based on 1 field as store_ID.
The flat have more than 5000 records. Problem is after every 385 records store_id from flat file comes as null. I deleted...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.