Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14 Answers
- 24425 Views
- Altisource, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / suresh
hi rachana
if here there are 100 tables
at that time we have to use 99 joins or is there any
another process for joining the 100 tables from diff
sources into to a single target
let me know if u know the answer
thanks for u r considiration
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / rachana
Use a Joiner Transformation to join the tables and load
into single target. Joiner tarnsformation can join
heterogenous sources
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / manish
we can use different target object for the same target table
and can load the data
| Is This Answer Correct ? | 1 Yes | 4 No |
Answer / gopi krishna k
write a pre sql which joins all 100 tables
Am I right?
| Is This Answer Correct ? | 0 Yes | 3 No |
When you move from devel to prod how will you retain a variable
What are the components of workflow manager?
in which situations do u go for scds ?
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
How will you combine 3 different sources with a single source?
enterprise datawarehouse your project phase by phase explain?
What are reusable transformations in how many ways we can create them?
What is the exact difference b/w IN and EXIST in Oracle..?
If we are using an aggregator but forget to mention the group by port .what will be the output??
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Explain reference cursor?
Where do we use mapping variables in informatica?
Teradata 
