two tables from two different databases r there . both
having same structure but different data . how to compare
these two tables ?
- 10 Answers
- 23284 Views
- HP, Patni, I also Faced
- E-Mail Answers
Answer Posted / bsgsr
if ur comparisiom means joining it shud be using joiner
t/tion using a join condition and join type
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Why update strategy and union transformations are active? Explain with examples.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the advantage of informatica?
What is a shortcut and copy in Informatica and how two are different with each other?
What is resilience time?
What is a predefined event?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How can we store previous session logs?
What are the main features of Oracle 8i with context to datawarehouse?
What are the different options available for update strategy?
Can you generate sequence numbers without using the sequence generator transformation?
What are the transformations that are not supported in mapplet?
What is a filter transformation and why it is an active one?
What is an aggregator transformation?
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
