odi-15050 flow control not possible if no key is declared in your target datastore

odi-15050 flow control not possible if no key is declared in your target datastore


Solution:
----------

In your interface target table don't have Primary Key or Unique Key.

Two ways we can resolve this issue.

1) Goto=> Interface=>QuickEdit=>Mappings

select one any id (ex: EMPNO) UK.






2)

Goto =>Models=UR Model(TARGET_SQL_MODEL)=>EMP(table)=>Constraints=>

Right click =>New Key=>Select Primary Key=>Got To =>Columns=>Move EMPNO to right side.

step by step giving Security through profiles and object wise providing

ODI-1551: The dbms_lock acquisition failed with a sql exception 'ORA-06550:

ODI-1551: The dbms_lock acquisition failed with a sql exception 'ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_LOCK' must be declared.

This issue you will get while running load plans.

Solution:
-----------
Grant  execute privileges on dbms_lock to ur schema( DB user for your work repository).


ex:

my schema name is :  ODI. (My Work Repository db user)


GRANT EXECUTE ON DBMS_LOCK  TO ODI;

ODI-1227 : Invalid Fetch Size while loading data from microsoft xls to oracle

ODI-1227: Task SrcSet0 (Loading) fails on the source MICROSOFT_EXCEL connection ODI_EXCEL.
Caused By: java.sql.SQLException: Invalid Fetch Size

 This is 11g bug.

so u can download the patch from oracle support (p12798243_111150_Generic)or

Follow the below solution.

 Solution:
-----------------

Goto => Physical Architecture =>Technologies=> Microsoft Excel=>Data Server

ex: i have created MOCROSOFT_EXCEL data server

open data server and change the Arry Fetech Size to zero (0).





 

How to find the all the task wise status after running your interface?

How to find the all the task wise status after running your interface?

OR

What are the tasks status available in sessions logs.?

------------------------------------------------------------------------------------

Using SNP_SESS_TASK table we can find the all the tasks status.

'D' - done
'E' - error
'M' - warning
'R' - running
'W' - waiting

How to find the no of records processed after running your interface?

How to find the no of records processed after running your interface?
------------------------------------------------------------------------------------

Using SNP_SESS_TASK_LOG table we can find the no of records processed.

TASK_DUR - Total duration
NB_ROW - number of processed records
NB_INS - number of insertion
NB_UPD - number of updates
NB_DEL - number of deletions
NB_ERR - number of error-out records.

Oracle Data Integrator Interview Questions and answers?

Oracle Data Integrator Interview Questions and answers?

1) What is the history of ODI?
2) What are the types of Knowledge Modules?
3) What are the types of data contol?
4) What is Journalization and why we are using in ODI?
5) Tell me step by step to enable Journalization?
6) What is An Interface ?
7) What is temporary Interface( Yellow Interface) ?
8) Tell me some differences between ODI 10g and ODI 11g?
9) Tell what are the ODI tools have u used in your project?
10) What are the Types of repositories in ODI?
11) Can i create more than one Master Repository in ODI?
12) What is a scenario in odi?
13) What is load plan and types of load plans in ODI?
14) What is CKM and when we will use this CKM?
15) What is SKM and when we will use this SKM?
16) What is package and main advantages?
17) Differences between package and loadplans?
18) How to load data from multiple files to single target?
19) How to load data from file to file and what are the KM's required for this requirement?
20) how to pass a variable more than one values?
21) What is an agent and What are the types of agents?
22) What is StandAlone Agent and default port number?
23) What is J2EE Agent and port number?
24) What is the use solutions?
25) What is flexfileds and use of flexfileds in odi?
26) What is CDC and explain complete CDC process flow?
27) What are the types of profiles in ODI?
28) What are the types of Generic profiles types in ODI?
29) Which profile required to access Models in Designer tool?
30) Which profile required to access solution in Designer tool?
31) Which profile required to access ODI Console?
32) What is ODI console?
33) What are types of LOG LEVELS in ODI?
34) What is the use of Markers?
35) What is memo?
36) How to move objects from DEV to QA and QA to PROD Environments?