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
Page views
Blog Archive
-
▼
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...
-
▼
December
(18)
Search
Popular Posts
-
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...
-
Format String Description AM, A.M., PM, P.M. Meridian i...
-
One QC process need to obtain tables and their row counts in a database in Netezza. We use the below SQL query to do so: "...
-
This is our input for demonstration. tAggregateRow vs tAggregateSortedRow in Talend I know these many columns not required but still wanted ...
-
In order to be able to execute bulk operations you need to certain level of privilege both on the database (table) you are performing the op...
-
When a connection is created from command line, multiple options need to provide in -o option: infacmd.sh createconnection [ICMD_10023] Miss...
-
Executing PMCMD command on UNIX and Syntax By Mahender on May 15, 2011 Steps to start workflow through PMCMD command, Generally we get be...
-
Error : ORA-31061: XDB error: special char to escaped char conversion failed. Cause : This is error is due to the presence of control chara...
-
REPLACHR is used to replace one character with another or remove particular character from a string 1. REPLACECHR ( ...
-
ERROR: "[ICMD_10033] Command [defineDomain] failed with error [[INFASETUP_10002] Cannot create the domain because of the fo...
0Awesome Comments!