top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

informatica mapping to count the no.of employees in each organisation

0 votes
359 views

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
posted Dec 18, 2014 by Amit Sharma

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

1 Answer

0 votes

Use an aggregator transformation with ORG as group by port. For EMP_COUNT, create an output port in the aggregator with the expression: COUNT(emp_id).

answer Dec 23, 2014 by Shweta Singh
Similar Questions
+2 votes
Informatica: how to get the auto-generated primary key of a table in Informatica mapping?

My question is very similar to the one below, but on a informatica environment:

Retrieving the index of an inserted row

Here is a brief summary of the issue: I'm trying to figure out how I can insert a row into a table and then find out what the value of the auto_incremented id column was set to so that I can insert additional data into another table. Our target is SQL server 2008. We have a table which has to be populated by informatica ETLs and the application is also using the same table - so, we can't use informatica sequence generator.

In the past when I have used Oracle database, there was a Oracle sequence generator transformation available in Informatica - but for SQL server, I am not sure.

Any solutions please?

0 votes
How to copy the data into one excel file at the time of mapping running in informatica?

I want to copy the data into one excel file, while the mapping has been running in informatica.

0 votes
replace null with 0 for the returned from count(*) function of aggregator in informatica

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.

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

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?

0 votes
find the list of mapping and workflow affecting the particular table in informatica

Can anyone tell me how to find the list of mapping and the workflow that are using a particular table say X either as a source or target table?

...