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
Answer Posted / 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 |
Post New Answer View All Answers
What are the types of presistent cache in look up tr.
Differentiate between router and filter transformation?
Explain the types of lookup transformation?
How to use pmcmd utility command?
What is dynamic cache?
What is the difference between source qualifier transformations source filter to filter transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
Under which circumstances, informatica server creates reject files?
what is diff b/t sorter t/r and agg have the option sorter property...
How many dimensions are there in informatica?
How do we call shell scripts from informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
waht type of interface is used for testing the data in informatica
What do you understand by term role-playing dimension?
What is resilience time?