Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

Teradata and Informatica Load constraints

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Teradata and Informatica Load constraints
# 1  
Old 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
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Solaris

Need help in configuring Password Constraints for Solaris 11.3

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

2. UNIX for Dummies Questions & Answers

Grep with time constraints

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

3. Shell Programming and Scripting

Parsing a file based on positional constraints

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

4. Solaris

Pkg update: No solution was found to satisfy constraints

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

5. UNIX for Dummies Questions & Answers

VPS has load 200, httpd load no activity, netstat nothing

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

6. UNIX for Advanced & Expert Users

GZIP memory constraints

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

7. Shell Programming and Scripting

Need help in wrting Load Script for a Load-Resume type of load.

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

8. Programming

About template constraints

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
Login or Register to Ask a Question

LEARN ABOUT REDHAT

set_constraints

SET 
CONSTRAINTS(7)						   SQL Commands 						SET CONSTRAINTS(7)

NAME

       SET CONSTRAINTS - set the constraint mode of the current transaction

SYNOPSIS

       SET CONSTRAINTS { ALL | constraint [, ...] } { DEFERRED | IMMEDIATE }

DESCRIPTION

       SET  CONSTRAINTS  sets  the behavior of constraint evaluation in the current transaction. In IMMEDIATE mode, constraints are checked at the
       end of each statement. In DEFERRED mode, constraints are not checked until transaction commit.

	      Note: This command only alters the behavior of constraints within the current transaction. Thus, if you execute this command outside
	      of an explicit transaction block (such as one started with BEGIN), it will not appear to have any effect.  If you wish to change the
	      behavior of a constraint without needing to issue a SET CONSTRAINTS command in every transaction, specify INITIALLY DEFERRED or INI-
	      TIALLY IMMEDIATE when you create the constraint.

       When you change the mode of a constraint to be IMMEDIATE , the new constraint mode takes effect retroactively: any outstanding data modifi-
       cations that would have been checked at the end of the transaction (when using DEFERRED) are instead checked during the	execution  of  the
       SET CONSTRAINTS command.

       Upon  creation,	a constraint is always give one of three characteristics: INITIALLY DEFERRED, INITIALLY IMMEDIATE DEFERRABLE, or INITIALLY
       IMMEDIATE NOT DEFERRABLE. The third class is not affected by the SET CONSTRAINTS command.

       Currently, only foreign key constraints are affected by this setting. Check and unique constraints are always effectively initially immedi-
       ate not deferrable.

COMPATIBILITY

   SQL92, SQL99
       SET  CONSTRAINTS is defined in SQL92 and SQL99. The implementation in PostgreSQL complies with the behavior defined in the standard, except
       for the PostgreSQL limitation that SET CONSTRAINTS cannot be applied to check or unique constraints.

SQL - Language Statements					    2002-11-22							SET CONSTRAINTS(7)