All Questions
Tagged with informatica-powercenter db2
12 questions
-1
votes
1
answer
171
views
Informatica PowerCenter passing Invalid date to the target table(DB2)
[IBM][CLI Driver][DB2/AIX64] SQL0545N The requested operation is not allowed because a row does not satisfy the check constraint.
Incorrect date - DT_AS_OF (DT_AS_OF:Date:): "06/03/0006 00:00:00....
0
votes
1
answer
283
views
Informatica DB2 DSN not working in Designer
I am trying to connect to DB2 database to import source structure. I tried using ODBC DB2 Wire Protocol Driver Setup. I provided IP Address, TCP Port, Location ( DB2 to Z/OS and Iseries), but when I ...
- 404
1
vote
1
answer
674
views
Join query failing in Informatica SQL transformation
I have a SQL query to which am passing parameters from expression transformation:
Eg:
SELECT A.id
FROM table1 A, table2 B
WHERE A.id = B.id
This works fine and am able to get the output.
...
- 398
0
votes
2
answers
493
views
Informatica SQ returns different result
I am trying to pull data from DB2 via informatica, I have a SQ query that pulls few fields based on joins for 4 different tables.
When I run the query directly in the database, it returns the ...
- 43
0
votes
2
answers
606
views
User defined join in Informatica with DB2
We are trying to replace source qualifier override with user defined joins and source filter.
for below user defined join in Informatica source qualifier:
{A INNER JOIN B ON a.dept_id= b.dept_id
b....
- 898
1
vote
1
answer
2k
views
Powercenter connectivity with DB2 400/AS400 with powercenter running on Windows 2012 r2
My requirement is to import DB2 400/AS400 tables to informatica powercenter. As i'm new to AS4oo db2 connectivity, i came to know that we can establish ODBC connection using "iSeries access ODBC ...
0
votes
2
answers
416
views
How to create a new record for the overlapping period between two records using Informatica/SQL
For below source data a new record needs to be created for the overlapping period and its the amount should be the sum of the overlapping record's amount. The start date and end date of the existing ...
0
votes
1
answer
4k
views
invalid datetime format
I have a question about powercenter message code: RR-4035. I have a mapping in which i am using a sql override query, this error is in sql override. This mapping is failing with an error,
'[IBM][...
- 57
0
votes
1
answer
858
views
Powercenter SQL1224N error connecting DB2
Im running a workflow in powercenter that is constatnly getting an SQL1224N error.
This process execute a query against one table (POLIZA) with 800k rows, it retrieves the first 10k rows and then it ...
- 357
0
votes
1
answer
2k
views
How to set no lock on tables in iseries/AS400
I have informatica ETL that will read the views and fetch data coming from DB2 iseries/AS400 but I have error saying "something in progress" I just want to know if there's a way in iseries to setup ...
1
vote
1
answer
789
views
how to call DB2 functions in Informatica ETL?
How to call DB2 functions in Informatica ETL?
Only used views in ETL before, have no idea how to do so for the functions, anyone got any idea?
- 5,665
1
vote
1
answer
1k
views
Database driver error >>The character " " following "ÃãÉåÉãèmÉÄ@" is not valid<< during session execution
I am getting below error at session level. kindly help me to fix this -
READER_1_1_1> RR_4035 SQL Error [
[IBM][CLI Driver][DB2/AIX64] SQL0007N The character " " following "ÃãÉåÉãèmÉÄ@" is not ...
- 111