i have different sources in different databases ,that
sources may be
100 tables i want to load these tables in to single target
how to
pearform the task
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 7 Yes | 1 No |
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.
Is This Answer Correct ? | 6 Yes | 1 No |
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 ???
Is This Answer Correct ? | 3 Yes | 0 No |
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.
Is This Answer Correct ? | 3 Yes | 0 No |
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.
Is This Answer Correct ? | 3 Yes | 1 No |
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. :)
Is This Answer Correct ? | 0 Yes | 0 No |
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
Is This Answer Correct ? | 0 Yes | 0 No |
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
Is This Answer Correct ? | 0 Yes | 0 No |
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.
Is This Answer Correct ? | 0 Yes | 0 No |
difference between shortcut and reusable transformation?
Explain lookup transformation source types in informatica
design of staging area?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
I want load the data into target with out 1st and last record.
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
How do we implement materialized view?when to use materialized view?
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
Explain the aggregator transformation?
How can you recover the session in sequential batches?