How to compare Source and Target table, without using
dynamic lookup?
Answers were Sorted based on User's Feedback
Answer / nagaraju bhatraju
YOu can join the Source and target columns at the source
qualifer level,if you have public synonym on the target, so
that the table can be accessed from all the schemas.
Is This Answer Correct ? | 6 Yes | 3 No |
Answer / davan
Am not sure ..default join of look is left out join
so...use of joiner t/r with left outer join..we have to
look up.
Is This Answer Correct ? | 1 Yes | 0 No |
In a table, 4 person having same salary. How to get Third person record only?
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Performance tuning in UNIX for informatica mappings?
How many repositories can we create in Informatica?
how to through logic of informatica using the push down optimization into oracle.
What is a design?
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query