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
- 20518 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 |
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
update strategy transformation in informatica
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
What are limitations of joiner transformation?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
What is IQD file?
what is data driven?
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
what is junk dimension
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
tell me the rules and responsblites in our project(my project is development)
Teradata 
