top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Icons do not show up in Informatica Mapping Designer

0 votes
399 views

I am new to Informatica and I am trying to learn it bit by bit.Currently I am able to enable the repository services but nothing works after I get connected. As in the transformation icons do not get highlighted when I open the mapping designer. Please find the attached screen-shot. Let me know if any questions.
enter image description hereThank you.

posted Oct 31, 2014 by Sachin

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

1 Answer

0 votes

You opened the Mapping Designer and connected to a folder but there is no mapping loaded - create a new mapping or open an existing one and transformations toolbar will become active.

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

My source File Description:
In creating a mapping in Informatica designer where in my source is a fat file which is the collection of different types of data, as in customer details from customer table, his enrollment details from enrollment table and few more tables like this.
In this scenario how do I proceed in creating mapping and transformation to target?
If it were a single source file I define a simple source and target mapping.

0 votes

I have some files that I would like to consolidate into a single database table. The files have similar but different formats. The files look something like this:

FileOne:
•ColA : string
•ColB : string
•ColC : string

FileTwo:
•ColAA : string
•ColBB : string
•ColCC : string

FileThree:
•Col01 : string
•Col02 : string
•Col03 : string

The destination table looks like this:

TableDestination:
•ColFirst : string
•ColSecond : string
•ColThird : string

I want to develop a mapping that ETLs these three files into this one database, but because the column names are different, it looks like I'll have to develop three different mappings, or three different sources, or three different somethings. The problem is that my example is contrived: I actually have many different files that all have different formats and column names, but the data is all very similar.

I would like to develop a single mapping or workflow that can handle all of this by only adding a table that holds the column mappings. Such a table would look like this based on the sample files and sample table above:

TableMappings:
enter image description here

In this way, to edit a column mapping I only have to make an edit this this TableMappings table. I wouldn't have to make any changes at all to the mapping or workflow. Nor would I have to redeploy an application.

What would a mapping or workflow look like that could take advantage of something like this? I assume there'd be a flat file source that takes files from a folder. There would be something in the middle that uses this TableMappings table to map column names. Finally there would be a relational data object that represents my destination database table "TableDestination". I don't know how to put this together though.

+2 votes

In my Informatica mapping, when an SP is called via an unconnected stored procedure transformation, the workflow succeeds. However there is a divide-by-zero error in the SP and ideally the workflow should fail. The source and target used in this mapping are dummy flat-files.

However, when I use dummy tables instead for source and target, with a connected SP transformation this time, the error bubbles up successfully.

Any idea why this would happen? Why does the error show only with source table and connected SP transformation, and not with flat-file source unconnected SP transformation?

+2 votes

I am working on Informatica PowerCenter Designer 8.1.1

I have a source table with three columns, which are
PORT_ID
ISSUE_ID
MKT_VAL

I need to sync the data from my source table to a target table which contains the same three tables on a different database.

There's a 1:n relationship between PORT_ID and ISSUE_ID

While doing this data Sync, I have to do a DELETE followed by INSERT, reason being, the number of ISSUE_ID mapped to a PORT_ID can change. Let's say that intially, the data was like this in Source and Target:

PORT_ID    ISSUE_ID
  1             A
  1             B
  1             C

The data in source gets changed to:

PORT_ID    ISSUE_ID
    1          A
    1          B
    1          D

Due to this, during my sync, I have to first delete all rows mapped to PORT_ID = 1 and then Insert the incoming records.

I am not able to figure out how I can get this done in mapping designer. Can someone give me some inputs?

+1 vote

A mapping just take 10 seconds to run, it takes a source file and insert into target, but before that there is a Stored Procedure transformation which takes around 5 minutes to run and gives output ‘Y’ or ‘N’. If Y then continue feed or else stop the feed. (Hint: since SP transformation takes more time compared to the mapping, it shouldn’t run row wise).

...