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
- 23960 Views
- Altisource, TCS, I also Faced
- E-Mail Answers
Answer Posted / gopi krishna k
write a pre sql which joins all 100 tables
Am I right?
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What do you mean by enterprise data warehousing?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is meant by lookup transformation? Explain the types of lookup transformation?
How you prepared reports for OLAP?
What is joiner change?
What is a router transformation?
How can you validate all mappings in the repository simultaneously?
Define filter transformation?
Is it possible to define a single node as a Gateway node as well as worker node?
Sequence generator, when you move from develoment to production how will you reset
Mention a few design and development best practices for informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Can we create a Integration service without a Repository service and vice versa?
How identifying bottlenecks in various components of informatica and resolving them?
