All Questions
5 questions
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
675
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
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
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 ...
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