Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
Answer Posted / abhinaw prakash
We can use lookup transformation to stay away from these
problem and can lookup the target columns befor entering the
data.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are batches?
Is stop and abort are same in informatica?
How many ways are there to do 'remove duplicate records in informatica'?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What does “tail –f” command do and what is its use as an Informatica admin.
Explain lookup transformation source types in informatica
Difference between Data and Index Caches?
Write the unconnected lookup syntax and how to return more than one column.
What is the use of target designer?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What are the types of caches in lookup?
What is decode in static cache?
If informatica has its scheduler why using third party scheduler?