This content has been marked as final. Show 11 replies
Are the following assumptions correct :
1. You are attempting to import a large number of tables through the following screen :
DAC -> Design -> Tables -> Click any of the table line and 'right Click' -> Choose 'Import from Database' -> Choose 'Import Database Tables' -> Choose the EBS data source and just enter a % on the table name filter -> click on 'Read Tables'
Is this what you did ? If yes, can you give us the name of the table you are unable to view in this list ?.. is it a bespoke table ?
Exactly as you said. I tried to lookup the tables with % or *.
Some tables examples:
I can see in the DB (with SQL Developer) but i can't see in DAC:
_# DIMENSIONAL TABLES_
XXOD_TABLE_ALPHA (It`s a customized table, but with apps user i can see this).
How i try to find the table in DAC:
DAC -> Design -> Tables -> Click any of the table line and 'right Click' -> Choose 'Import from Database' -> Choose 'Import Database Tables' -> Choose the EBS data source (WITH APPS USER)
When i put %XXOD% i can see some customized tables, but not everyone. The same thing happen with Dimensional DB.
What can i do for resolve this issue?
This is what I am **guessing** is happening (do let me know if you manage to resolve the issue - I'd like to know what worked in the end) :
- Remember the fact that DAC is integrated to Informatica
- The import tables feature in DAC will perhaps only import tables that are registered as a 'Source' / 'Target' for any of the tasks
- Are you able to test this assumption by updating any mapping to include the required tables as a source ?