06-05-2014
Teradata and Informatica Load constraints
HI Team ,
I have interesting issue observed when using teradata sql assistant(14.1) and Informatica tool (9.5) versions.
I created SQL code in teradata where source count is 5000 records . I am using source and target database as teradata and trying to load using informatica tool . Its straight forward mapping with source>>sqlcode>>expression>>target.However on successful workflow run success rows (5000) does not match with Success target rows (4000) . I dont see any error /bad file entry.But when i query target table in teradata i see 5000 records.
During teradata installation i used system dsn with ODBC connections as default for transaction mode details . We do have option to select as ANSI or normal option.So my point is why counts are not matching when loaded using teradata.Teradata's default transaction mode rolls back entire transaction to last commit point whenever a sql statement fails. This is unlike ANSI transcation mode, which only fails the current statements and does not really rollback the entire transaction.
Please let us know if any configuration changes need to be applied either @informatica admin console level or in Teradata ODBC driver (currently session mode is set as “system default “ .Should that be changed to ANSI or Teradata ?
Please help me to resolve the issue .Are there any set of connection changes to be done while working with informatica?
I verified in lots of blogs and could not find any solution.
Any help appreciated.
Thanks
8 More Discussions You Might Find Interesting
1. Programming
Hi, i have class template,
1)can i override the copy constructor
2)can we have virtual function in class template
if not plz tel why? I tried , compile error comes for me...
Thanks
Sarwan (0 Replies)
Discussion started by: sarwan
0 Replies
2. Shell Programming and Scripting
hi all
need your help.
I am wrting a script that will load data into the table.
then on another load will append the data into the existing table.
Regards
Ankit (1 Reply)
Discussion started by: ankitgupta
1 Replies
3. UNIX for Advanced & Expert Users
Currently I am using the ZLIB_VERSION "1.2.3" . The memory requirement for Zlib/GZIP compression is stated as
/* The memory requirements for deflate are (in bytes):
(1 << (windowBits+2)) + (1 << (memLevel+9))
that is: 128K for windowBits=15 + 128K for memLevel = 8 (default... (0 Replies)
Discussion started by: Parmod Garg
0 Replies
4. UNIX for Dummies Questions & Answers
Hello, on my hostserver i see one VPS of mine got load of 200.00 and netstat nothing (not a single blank line on netstat command) after some time, netstat started showing connections, but i see no excessive IP connections.
tail -f /var/log/httpd/access_log shows no activity
/var/log/messages ;... (1 Reply)
Discussion started by: postcd
1 Replies
5. Solaris
I have an x86 Solaris box running 11.2 and have run into the following issue when attempting to run a package update. Has anyone else come across this issue and resolved it successfully, or am I waiting on Oracle to release other updated packages?
uname -a
SunOS <hostname> 5.11 11.2... (13 Replies)
Discussion started by: nova_cyclist
13 Replies
6. Shell Programming and Scripting
I have a list file1 like
dog
cow
fox
cat
fish
duck
crowI want to classify the elements of file1 based on constrains applied on file2. Additionally the number of elements (words) in the each line of file2 is not fixed. This is my file2
cow cat fox dog
cow fox dog
fish crow fox dog cat ... (5 Replies)
Discussion started by: sammy777
5 Replies
7. UNIX for Dummies Questions & Answers
Hello Friends -
I am trying to grep certain messages that have a time slot like this:
MyRate=33FC|SystemDEF=445DE|Calc=33W2|Time=15:50:24
I am trying to grep everything after Time=15:50:26 including SystemDEF=E2S and Calc=33W2 into a file called myrate.dat
Not able to... (7 Replies)
Discussion started by: DallasT
7 Replies
8. Solaris
Hello Friends
I was running Solaris 11.3 x86.
Below is my configuration to set password Constraints.
more /etc/default/passwd
MAXWEEKS=4
MINWEEKS=1
WARNWEEKS=1
PASSLENGTH=8
NAMECHECK=YES
HISTORY=4
MINDIFF=3
MINALPHA=2 (4 Replies)
Discussion started by: jebby123
4 Replies
LEARN ABOUT PHP
db2_rollback
DB2_ROLLBACK(3) 1 DB2_ROLLBACK(3)
db2_rollback - Rolls back a transaction
SYNOPSIS
bool db2_rollback (resource $connection)
DESCRIPTION
Rolls back an in-progress transaction on the specified connection resource and begins a new transaction. PHP applications normally default
to AUTOCOMMIT mode, so db2_rollback(3) normally has no effect unless AUTOCOMMIT has been turned off for the connection resource.
PARAMETERS
o $connection
- A valid database connection resource variable as returned from db2_connect(3) or db2_pconnect(3).
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Rolling back a DELETE statement
In the following example, we count the number of rows in a table, turn off AUTOCOMMIT mode on a database connection, delete all of
the rows in the table and return the count of 0 to prove that the rows have been removed. We then issue db2_rollback(3) and return
the updated count of rows in the table to show that the number is the same as before we issued the DELETE statement. The return to
the original state of the table demonstrates that the roll back of the transaction succeeded.
<?php
$conn = db2_connect($database, $user, $password);
if ($conn) {
$stmt = db2_exec($conn, "SELECT count(*) FROM animals");
$res = db2_fetch_array( $stmt );
echo $res[0] . "
";
// Turn AUTOCOMMIT off
db2_autocommit($conn, DB2_AUTOCOMMIT_OFF);
// Delete all rows from ANIMALS
db2_exec($conn, "DELETE FROM animals");
$stmt = db2_exec($conn, "SELECT count(*) FROM animals");
$res = db2_fetch_array( $stmt );
echo $res[0] . "
";
// Roll back the DELETE statement
db2_rollback( $conn );
$stmt = db2_exec( $conn, "SELECT count(*) FROM animals" );
$res = db2_fetch_array( $stmt );
echo $res[0] . "
";
db2_close($conn);
}
?>
The above example will output:
7
0
7
SEE ALSO
db2_autocommit(3), db2_commit(3).
PHP Documentation Group DB2_ROLLBACK(3)