top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

Record count increases in PreSQL-Informatica in the absence of Semicolon(;), Database : Teradata

0 votes
104 views

My PreSQL query in the WorkFlow of Informatica has 2 parts:

Insert query
Refresh Stats procedure call
When no semicolon ; is present between these 2 parts, the record count is given in Millions. When a semicolon ';' is present the record count is given in Thousands.

Two Questions:

Why is it not throwing an Error for the absence of a semicolon?
Why the increased record count?

posted Aug 25, 2014 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

From the documentation:

Use a semicolon (;) to separate multiple statements. The Integration Service issues a commit after each statement.
The Designer does not validate the SQL.

It will not throw an error in power center because is not validating it. You can check logs on what SQL is getting passed to teradata and execute the same outside (any other client) to investigate on the row count diffference.

answer Aug 26, 2014 by Shweta Singh
Similar Questions
0 votes

PreSQL and postSQL in Informatica is not getting executed.

ISSUE DESCRIPTION :

I have table in Microsoft SQL server. I am trying to update/insert this table using Informatica powercenter session by calling SP through Stored Procedure Transformation. But its not happening. After further digging up, I got to know that reason behind this are triggers on table that we are trying to update/insert. There are couple of triggers defined on the table and it has got on insert and on update triggers also. So I thought of disabling all the triggers on the table in PreSQL and enable them back again in postSQL of the session that I am running. But its not working. However when I execute the trigger disable statement directly on DB through Microsoft SQL server client and run the session, session is updating/inserting the records.

Below are the Presql and postSQL commands used by me:

BEGIN TRANSACTION
ALTER TABLE schemaname.tablename DISABLE TRIGGER ALL
commit;

BEGIN TRANSACTION
ALTER TABLE schemaname.tablename ENABLE TRIGGER ALL
commit;

Please let me know if I am going wrong anywhere/if there is any possible resolution for this.

0 votes

Teradata : JANUVIA - 50MG – TABLET - 1 BLISTER - 28 TABLET (28.TA) ORacle: JANUVIA - 50MG ? TABLET - 1 BLISTER - 28 TABLET (28.TA)

We are using code page 'ms windows latin 1 (ansi) superset of latin1' for source connection i.e. Teradata.

We are using code page UTF 8 for target

0 votes

I am trying to get a resultset from Teradata stored Procedure to my Mapping.

The stored procedure is to hold multiple select statements and the final output is to be sent to informatica. Below is a sample of how the select statement looks like

sel 'INH1' AS QC_CODE,count(*) from Table 1 
UNION
sel 'INH2' AS QC_CODE,count(*) from Table 2   
UNION
sel 'INH3' AS QC_CODE,count(*) from table 3

I need a stored procedure that can send the output of the above query (2 columns, 3 records) to Informatica, where I can call the stored procedure in my source qualifier or through SP transformation

Any help??

0 votes

can anyone tell me how to create mapping for the following scenario:

Source:                 Target:
emp_id  org             EMP_COUNT  ORG
1         x                2         X
2         Y                2         Y
3         X                1         z
4         Y
5         Z
0 votes

I am using aggregator transformation in my Informatica mapping where I am counting number of records coming from sql override.I need to pass zero value to target table as counts in case if I get 0 number of return counts from count(*) function of Aggregator Transformation.

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...