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
- 24928 Views
- HP, Patni, I also Faced
- E-Mail Answers
Answer Posted / janani
We can use lookup Transformation and expression to compare
the data
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Describe expression transformation?
How to load a Dimension ? and how to load a fact table?
Can you use flat files in Mapplets.
What is union transformation?
What are the different ways to implement parallel processing in informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is the difference between source qualifier transformations source filter to filter transformation?
What is informatica?
How will the document be delivered to me?
If informatica has its scheduler why using third party scheduler?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is Cognos script editor?
How can you define user defied event?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
