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
- 21317 Views
- Altisource, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Explain your project of banking domian.
What is a snowflake schema?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is Cognos script editor?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Enlist the tasks for which source qualifier transformation is used.
What you know about transaction control transformation?
Under which circumstances, informatica server creates reject files?
What does cheating measurement mean?
How to join three sources using joiner?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain sql transformation in script mode examples in informatica
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How do you migrate data from one environment to another?
