two tables from two different databases r there . both
having same structure but different data . how to compare
these two tables ?
- 10 Answers
- 23341 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
Can we create a Integration service without a Repository service and vice versa?
Explain the types of lookup transformation?
What is different between the data warehouse and data mart?
Explain what transformation and how many are there in informatica?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is a connected transformation?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
How you can differentiate between connected lookup and unconnected lookup?
What are the differences between joiner transformation and source qualifier transformation?
How many ways a relational source definition can be updated and what are they?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How does the aggregator transformation handle null values?
Under which circumstances, informatica server creates reject files?
What is domain and gateway node?
What is the difference between informatica 7.0 and 8.0?
