top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Import data from db2 using informatica power Center without powerexchange

+1 vote
676 views

How to Import data from db2 table using informatica power Center without powerexchange.

posted Nov 21, 2014 by Sachin

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

1 Answer

0 votes

1.Create DB2 Source definition from DDL of the table.
2.Create the Relational DB2 Connection in the Workflow manager.
3.Get the connection string mapped to correct DB2 URL from your admin.
4.Choose the connection string just created in source properties.
5.
Insert the User-name and password in the Relational connection.

and you'll be able to connect to DB2.

answer Nov 24, 2014 by Shweta Singh
Similar Questions
0 votes

I have a requirement where I need to obtain the number of rows written to multiple targets in my mapping. There are 3 targets in my mapping (T1, T2 and T3). I need the number of rows written to each target separately. These values need to be used in subsequent sessions. I understand that there is a method where I can use separate counters and write them to a flat file and perform a lookup on this file in subsequent mappings. However, I am looking for a direct and better approach to this problem.

+1 vote

SQL SERVER 2014 SSIS has been released,we have already got lot of facilities in SQL SERVER 2012 SSIS.Can anybody compare SSIS 2014/SSIS2012 with Informatica Power center ? What are the additional fetures are there in the Informatica new version than SSIS 2012/2014? Or are there functions in SSIS 2014/20122 ,which are not available in Informatica.

+1 vote

I have two sources (source A and Source B), source B is an another one target table in my db. both are in diff user id . Now i have to transfer some data,s from these two sources to target table. Can i transfer data without using the joiner transfermation? how to do ?

0 votes

I tried the SQ and linked directly from source to SQ only the required columns and generated workflow but it shows no result. Do I have to use any other transformation or do I have to add query in SQ if so how? help me thanks in advance.

...