skip to main
|
skip to sidebar
About
Contact
Today :
Tech Netting
Home
Metadata Query to get ODI Session Log
0
select SESS_NO,SCEN_TASK_NO,TASK_STATUS,DEF_TXT,TASK_NAME3,ERROR_MESSAGE from
dev_odi_repo
.snp_sess_task_log where sess_no=
49100
0
Awesome Comments!
Leave Your Response
Newer Post
Older Post
Home
Page views
Blog Archive
►
2021
(4)
►
August
(1)
►
May
(1)
►
February
(2)
►
2020
(10)
►
November
(1)
►
October
(2)
►
September
(2)
►
August
(1)
►
May
(3)
►
March
(1)
►
2019
(3)
►
May
(1)
►
January
(2)
►
2018
(14)
►
December
(2)
►
November
(3)
►
October
(1)
►
June
(1)
►
May
(1)
►
March
(2)
►
February
(2)
►
January
(2)
►
2017
(37)
►
November
(1)
►
October
(8)
►
September
(1)
►
August
(1)
►
July
(1)
►
May
(5)
►
April
(9)
►
March
(6)
►
February
(1)
►
January
(4)
►
2016
(36)
►
December
(4)
►
November
(4)
►
October
(3)
►
September
(5)
►
August
(3)
►
June
(2)
►
May
(2)
►
April
(3)
►
March
(4)
►
February
(2)
►
January
(4)
►
2015
(75)
►
December
(4)
►
November
(1)
►
October
(1)
►
September
(6)
►
August
(2)
►
July
(3)
►
June
(6)
►
May
(19)
►
April
(11)
►
March
(16)
►
February
(3)
►
January
(3)
▼
2014
(18)
▼
December
(18)
Removing Special Characters from a string field in...
Query to get count of all tables in a database/schema
Query to get count of all tables in a Oracle Datab...
What is the approximate size of a data warehouse?
Arithmetic Calculation in Shell Scripts
OBIA 11.1.1.7.1 / 11.1.1.8.1 Custom BIACM Offering...
BEWARE OF THE PREDICATE IN THE OUTER JOIN
Different SQL Statement Types
ORA-32486: unsupported operation in recursive bran...
How to Restore Oracle Database using RMAN (with Ex...
How to Backup Oracle Database using RMAN (with Exa...
Metadata Query to get ODI Session Log
Stop on Errors
Database Link creation using Oracle Description
Synonym Reverse Engineering in ODI
Parameterizing Schema's in Informatica
Difference between queries using "where clause" an...
Things need to be checked while writing jobs for F...
Search
Popular Posts
Talend MetaServlet API
How Jobs are handled via Talend Administration Center Talend Jobs are scheduled from Talend Administration Center , which provid...
Operation not allowed for reason code “7” on table in DB2
This issue generally occurs when we altered/modified already existing table in IBM DB2. We have to execute below Query when we get this erro...
Resume from the last checkpoint.
Recover Strategy for Session Task: For session the Informatica provides three options of recovery as following: · Resum...
Things to remember about Update Strategy .
Mapping with Update Strategy and Bulk mode as load type will run in normal mode as below: Mapping with Update Strategy and Treat rows as Ins...
tAggregateRow and tAggregateSortedRow in Talend
This is our input for demonstration. tAggregateRow vs tAggregateSortedRow in Talend I know these many columns not required but still wanted ...
Trace in Oracle
v$process v$session EXEC DBMS_SYSTEM.set_ev(sid, serial#, event, level, name); EXEC DBMS_SYSTEM.set_ev(31, 97, 10046, 4, '');
Setting the Java path in Talend
For Studio Stop Studio. In the installation folder of your Studio, where the executable you are using is located, edit the ini file ...
REPLACECHR in Informatica
REPLACHR is used to replace one character with another or remove particular character from a string 1. REPLACECHR ( ...
The differences between Unique match, First match and All matches
This article uses examples to illustrate the differences of the three match models. These three match models mentioned in the tit...
Split large files into a number of smaller files in Unix
To split large files into smaller files in Unix , use the split command. At the Unix prompt, enter: split [options] filename prefi...
Labels
Informatica
Mysql
ODI
Oracle
SQL Server
Talend
0Awesome Comments!