Hi,
Here are few things u need to try:
* As empl and details tables are very big, u must partition these tables(this will help query performance)
* Try to create indexes (use bitmap indexes) whereever applicable.
* Have you analyzed these tables and computed statistics?
* If you are going for...
Hi Narshimha,
In session properties,
1: click 'Target Options'
2: In 'Target Load Options', clik 'Normal' radio button and 'Test Load' check box is enabled.
3: Check 'Test Load' and give no.of row you want to test load.
Hope this helps...
tkrish.
Hi Vikind,
As you know which columns are not nullable in the target table, i suggest the following approach:
Have an expression transformation A for which input ports are STATE and VERSION.
OUT_ERR = IIF((STATE='NONE' OR VERSION='NONE'),
'ERROR',
NULL)
This value...
Hi cognav,
Informatica does support loading only changed records.
For this u can have two flows in ur mapping. One which does an update based on some primary key of the table and another flow which does an insert.
Update transformation can be used to update existing records.
tkrish
Hi INFEXP,
You can split your mapping into two different flows.
Do the insert in one flow and in the other flow do the update.
It should be a very simple change.
tkrish
Use Advanced External Procedure transformation and have a perl program that does all the parsing for you.
Search for "Perl output strings" in Help topics and you'll find a nice article describing all the steps.
tkrish.
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.