top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica target table populating

0 votes
189 views

am new in Informatica,here i am trying to populate my target table by joining two tables where the no. of rows in both the table is 5649 and 2611 respectively.So, my output rows should be 8260.But the no. of rows rows in target table is around 108860 (approx.).

Why this is happening and how should I remove it?

posted Jul 3, 2014 by Sunil

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

1 Answer

0 votes

You need to merge two sets of rows into one, so use a Union transformation, not a Joiner.

answer Jul 9, 2014 by Shweta Singh
Similar Questions
0 votes
Running SQL against the source in Informatica and exporting results to a target table

Using Informatica designer, is there a way to run a complex SELECT statement as-is against a source database, and workflow it into a target table? For example, SQL Server Integration Services makes it really easy to create source/target connections, paste your source SQL, and map the results to the target table. When the package is run, SQL runs against the source, and results are dumped into the target.

Is something like that available in Informatica?

+1 vote
Informatica: Converting a table into multiple target tables based on one column.

In my source table data is 

s_name,p_name,value
s1 ,   p1,     10
s1 ,   p2,     xyz
s1 ,   p3 ,    abc
s2 ,   p1 ,    20
s2 ,   p2 ,    xyz
s2 ,   p3 ,    abc

I want two target tables, first table is based on s_name s1, second table based on s_name s2. Both table contains contains p_name and value.

The target table data like as

Table s1

p_name,value 
p1,    10
p2,    xyz
p3,    abc

Table s2 

p_name,value 
p1,    20
p2,    xyz
p3,    abc
+1 vote
How to map the informatica for the inserts and updates to the target from source table?

Can anyone of you please elaborate on how to map the informatica for the inserts and updates to the target from source table?

I appreciate it, if you explain with example.

+2 votes
Informatica metadata table - Primary key column from target table

Couple of tables in our Database doesm't has any key. However, key was created in target table at informatica level.

Now my need is, need to identify informatica metadata table where I can find tgt table and corresponding column name marked as key.

Kindly suggest

+1 vote
How to transfer data to the target table from multiple sources without using Joiner Transformation in informatica?

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 ?

...