Answer / dada

Hi Guys,

We can use union transformation to join 100 tables.but the
thing is it should be same structure.by using one union we
can do it. for ex all 100 tables have same order,datatype
(std_name,loc,dept) then only we can do it by union.

Answer / bsgsr

after reading the above answers i find one is left joining
the tables in the database itself rather than joinng them
in the session using 99 joiners. it would also increase
performance.

Answer / prashant

Hello Bsgsr,

thats is one of poosible sol, we can do it only when all
the source's are Relational.
what in case if the source is a mix of Homegeneous and
Hetrogeneous ???

Answer / bidhar

If the structure of 100 tables and the target table are
same then what is the use of joiner??

Here you need to do a Union.


If the structure of 100 tables and the target table are not
same then joiner should be used.
That means you will be picking up the desired Attributes
(columns) from these 100 tables and populating into the
target.

Please let me know your question clearly.

Answer / pushparao

joiner transformation is used for combining the columns of the
different tables with common column horizontally with respect
to data of the columns.
union transformation is used to combined data for the common
columns.
or
simply joiner transformation-->Horizontal collection of the
columns.
union transformation-->vertical collection of rows.

Answer / pentaho

v can use user define join ........

Answer / sanjay

well if u hav all related sources then u can probably go
for joiner but make sure that use less no. of joiner as it
may decrease your performance.
if u hav sources with same structure and data types then u
can probably go for set operation and matchin it with your
target.
the third one is u hav to do a lot of transformation based
on some analysis and might be u can create differnet
aliases for your target and you can apply your
transformation.


plz let me know if any clarification . your comment will be
appreciatable. :)

Answer / tauseef

hai Taueef

As per above requirement my suggestion is
if the sources having similar columns then we go with union

if there is no similar columns add dummy port on all d source and use joiner transformation

Answer / kumar

Hi Gurus,

can anyone please explain performance tuning above logic. If multiple sources are coming from multiple databases.
Not simple use Unioni/ Joinder T/R.

Please be patience.. your explanation is very helpful to us.

thanks in advance

Answer / nitin tomer

Best solution as per my knowledge is below, i am assuming all tables are in DB.

1)Create a meta data table in your target DB with the three columns source_table_name,Target_table_name and Flag.
2)Use SQL transformation in informatica in Query Mode and give the required connections
3)Configure the SQL transformation and give the generic queries
create table ~Target_table_name as select * from ~source_table_name;
~source_table_name and ~Target_table_name: It will take from the meta data table

In this way you can automate this process and can load as many tables you want just you have to give table name entry in meta data table.
Write me @thisistomer@gmail.com if you have any doubts.

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

0 Answers  

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

3 Answers   IBM, ITC Infotech,

hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,

How to update records in Target, without using Update Strategy?

3 Answers  

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

Explain why we use partitioning the session in informatica?

0 Answers  

Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  

diffrence between command task and control task

1 Answers   iNautix,

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

0 Answers  

How can you complete unrcoverable sessions?

1 Answers  

What is joiner change?

0 Answers