How to Validate source data before loading into Target data?
Hi Experts, How to perform validation checks for source data like excel file before loading correct data into Target like SQL SERVER 2008 database. With Regards, Viswanath.
Hi Xdshi,
Thanks for your response. Let me put my requirement in simple way.
1. I have a table data in informix (let us say t1 is the table and employee_id is the column name and the data from 1 to 10 is present)
2. This data is moved to oracle using some XXXX tool
3. Now i will have to check that in Oracle table (let us say t1_1 is the table and employee_id is the column and the data is moved 1 to 9 only but the 10 is missing in oracle)
4. This missing 10, I would like to capture in the excel.
Please do needful. thank you.
Hi Sabrina,
I am trying to connect oracle and that was successful but when I try to retrieve schema in the retrieve schema page- page is keep on loading and i am unable to move to NEXT page. My db is huge too. Are there any simplest way or workaround to handle it? Help appreciated. thank you.
Thanks for your response. Let me put my requirement in simple way. 1. I have a table data in informix (let us say t1 is the table and employee_id is the column name and the data from 1 to 10 is present) 2. This data is moved to oracle using some XXXX tool 3. Now i will have to check that in Oracle table (let us say t1_1 is the table and employee_id is the column and the data is moved 1 to 9 only but the 10 is missing in oracle) 4. This missing 10, I would like to capture in the excel.
The solution provided in previous post will achieve your goal:
toracleinput-->tMap (
inner join on your input sources "primary key
employee_id
" and set the "Catch lookup inner join reject" as true)-->outputexcel
tinformixinput-->
Hi Sabrina,
One more question, let us say i have two informix tables which needs to be joined and then one oracle table join these two tables using tmap and then output in excel. So ihave done one informix table and one oracle table before but i haven't tried two informix table and one oracle table. Please guide me.
One more question, let us say i have two informix tables which needs to be joined and then one oracle table join these two tables using tmap and then output in excel. So ihave done one informix table and one oracle table before but i haven't tried two informix table and one oracle table.
Could you please show us your current job design flow? What's the problem you got?
Best regards
Sabrina
Hi Sabrina,
I have the following scenario, could you please advice.
Informix - schema1-> table1
informix - schema2 -> table2
Need to join these two tables to get columns from both using some common keys. Once this step is completed then compare the result set of the above scenario with another migrated schema (oracle db) ie, one table - which is having columns of (table1 & table2 of informix). Finally bring the rejectedrows as output into excel.
Hi
smathan,
From your description, you can use tMap to achieve it also.
The workflow should be:
tOracleInput
|
(join
migrated schema from oracle and
table1 & table2 of informix
Informix
(source1)-->tMap(common key)------------------->tMap_2
set the option"catch output reject" as true in tmap)----
-->tfileoutputexcel
Informix
(Source2)
Hi Sabrina,
I was trying the same logic just myself and it worked out! Feel very happy that i did it in first time. Our productivity become more after we introduce DI tool in our department. thanks for your response as well.
