How to Join Tables my Source is having 15 table target is
one?
- 4 Answers
- 7320 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / balu024
if you have same meta data in all 15 tables, then you can join
those tables by using union transformation
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is aggregator transformation in informatica?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
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 the surrogate key?
Why union transformation is an active transformation?
What is meant by pre and post session shell command?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How can you define user defied event?
How to extract sap data using informatica? What is abap? What are idocs?
How to elaborate powercenter integration service?
As union transformation gives UNION ALL output, how you will get the UNION output?
Differentiate between router and filter transformation?
What is meant by target load plan?
Explain in detail scd type 2 through mapping.
