You may know or may not that Informatica has pecular repository and methods of change propagations that are not all so "simple" least said.
Now,if Your Informatica is installed on Oracle Server that what You can do:
1.create dblink to You infa server
2.create directories on Your infa server:
examples:
create directory R_BAD as '/etl/stage001/BadFiles/R/
3.create some structures to authomatically create external tables in the directory
Now,You have unique ability to run the comparisons of Your database data with Infa server data(see example) and create views poiting there
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: | create view v_infa_source_logs (source_name,
mapping_name,
target_name
)
AS
SELECT NVL (s.source_name, 'NO SOURCE') source_name, t.mapping_name,
t.target_name
FROM informatica.rep_src_mapping@p_etl s,
informatica.rep_targ_mapping@p_etl t,
informatica.rep_sess_tbl_log@p_etl l
-- WHERE
WHERE t.mapping_name = s.mapping_name
AND s.subject_area = 'PROD'
AND s.subject_area = l.subject_area
AND s.source_name = l.table_name
|
Thanks for Your comments.
I do think this article almost adhers to the guidlins,let me put those inside ,I agree,I wrote it for experts,I'll try to refrase and yes,English is not my 1st language.
Ok,let's try:
1. A statement of the problem being resolved or issue being discussed
You may know or may not that Informatica has pecular repository and methods of change propagations that are not all so "simple" least said.
That meaning Informatica is ETL,extraction transformation language, tool serving wide array of data transformation tasks.
Here I'm trying to facilitate it's repository which is basically Informatica internal database . The problem is that this database is not very easily accessible. There are tools provided by Informatica which cost a lot and not widely used because of that. I'm trying here to show a way around to use gthe repository.
2. A description of the resolution of the problem
Let's say You've created a dblink to Your Infa repository.
Then You can use following code to ncreate views:
create view v_infa_source_logs (source_name,
mapping_name,
target_name
)
AS
SELECT NVL (s.source_name, 'NO SOURCE') source_name, t.mapping_name,
t.target_name
FROM informatica.rep_src_mappin
informatica.rep_targ_mappi
informatica.rep_sess_tbl_l
-- WHERE
WHERE t.mapping_name = s.mapping_name
AND s.subject_area = 'PROD'
AND s.subject_area = l.subject_area
AND s.source_name = l.table_name
3. A summary of the above two segments.
In summary.we can use simple Oracle methods to explore Infa repository and have it handy to the users