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
- 21323 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 |
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
What is enterprise data warehousing?
What is difference between a connected look up and unconnected look up?
if i am having 10 records in source, i want 20 records in target...how will you do it
difference between informatica 8.1.1 and 8.6
what is update strategy transformation ?
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
What is data movement mode in Informatica and difference between them?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
what happens when a batch fails?
wat are deployement groups in informatica, how it will be used for developers
How to use pmcmd utility command?
Teradata 
