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
- 21324 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
What is a node in Informatica?
Make a note of the quantity vaults made in informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Mention few advantages of router transformation over filter transformation.
State the differences between sql override and lookup override?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
where to store informatica rejected data?
Explain the use of aggregator cache file?
Explain what is informatica metadata and where is it stored?
Describe expression transformation?
What is a surrogate key?
What all join we can perform in LOOKUP transformation?
How to extract sap data using informatica? What is abap? What are idocs?
Differentiate between reusable transformation and mapplet.
What is intricate mapping?
