Regarding an issue we are facing from last sunday(26thmay2013) the following workflow is facing a scenario,
where the workflow continues to run but no data is getting inserted into the Shown Target Table.
we could see that the Process has run for nearly One whole day, but not even a single row has been inserted.
We tried creating a similar mapping with the same source and target tables, still facing the same issue.
Can you kindly provide your inputs in this regard?
Your table will not have any entry since session has not completed yet.
Also I can see from log that informatica has not even returned first row.It has issued SQL to DB and waiting for it to complete.
You ran this SQL in toad/SQL developer and you will never get a row.
SELECT XX_BATCH_DETAILS.REQUEST_ID, XX_BATCH_DETAILS.REQUEST_DATE, XX_BATCH_DETAILS.BATCH_ID, XX_BATCH_DETAILS.BATCH_NUMBER, XX_BATCH_DETAILS.BATCH_STATUS, XX_BATCH_DETAILS.ORGANIZATION_ID, XX_BATCH_DETAILS.ORGANIZATION_CODE, XX_BATCH_DETAILS.ORGANIZATION_NAME, XX_BATCH_DETAILS.INVENTORY_ITEM_ID, XX_BATCH_DETAILS.ITEM_CODE, XX_BATCH_DETAILS.ITEM_DESCRIPTION, XX_BATCH_DETAILS.CHARGE_TYPE, XX_BATCH_DETAILS.CHARGE_TYPE_SUBCATEGORY, XX_BATCH_DETAILS.CHARGE_ITEM_ID, XX_BATCH_DETAILS.CHARGE_ITEM_CODE, XX_BATCH_DETAILS.CHARGE_ITEM_DESCRIPTION, XX_BATCH_DETAILS.TRANSACTION_DATE, XX_BATCH_DETAILS.INGREDIENT_QUANTITY, XX_BATCH_DETAILS.UOM, XX_BATCH_DETAILS.INGREDIENT_COST_RATE, XX_BATCH_DETAILS.INGREDIENT_VALUE, XX_BATCH_DETAILS.BATCH_QUANTITY, XX_BATCH_DETAILS.BATCH_RATE, XX_BATCH_DETAILS.DAILY_BATCH_QUANTITY, XX_BATCH_DETAILS.MONTHLY_BATCH_QUANTITY,XX_DAILY_ITEM_COST_V.ITEM_COST
XX_BATCH_DETAILS, XX_DAILY_ITEM_COST_V where
and XX_DAILY_ITEM_COST_V.organization_id(+)= XX_BATCH_DETAILS.organization_id
and XX_DAILY_ITEM_COST_V.transaction_date(+)= XX_BATCH_DETAILS.transaction_date
You might need to recheck your source system and show your DBA's to tune the DB.
Mark helpful or correct if it helps,
Thanks for the update Veersh.
But can you kindly,be a little more clear and specific?
We cant figure out anywhere for a solution for this issue.
We have been stuck up with thiis for the past four days.
What exactly do we have to do, to sort this out.
But tell me how long that SQL took the time to get you the first row in toad?..Is there anything u missed out in Session log after this statement query issued to Database ?.If yes please post the remainging session log too.
If nothing remained in the session log then do these action itmes.
1)Check if there is any table lock happended on those source tables.
2)Abort the ongoing ETL process and mark as completed and then start the process freshly.Monitor operating system RAM utilization closely and hows RAM is getting utilized.
Mark as correct or helpful if it helps,