Interested to Buy Any Domain ? << Click Here >> for more details...
two tables from two different databases r there . both
having same structure but different data . how to compare
these two tables ?
- 10 Answers
- 24929 Views
- HP, Patni, I also Faced
- E-Mail Answers
Answer Posted / srinivas chowdary
If the Tables from two different datbases we should go with
Joiner Transformation.
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
What is Session and Batches?
What is the need of etl tools?
Explain dynamic target flat file name generation in informatica
What is a joiner transformation?
What is meant by lookup transformation?
Define mapplet?
How to generate sequence numbers?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
In how many ways we can create ports?
Global and Local shortcuts. Advantages.
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 if the source is a flat-file?
What are the types of lookup transformation?
How do you change a non-reusable transformation to reusable transformation?
