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 is a surrogate key?
Explain the use of aggregator cache file?
Explain what transformation and how many are there in informatica?
Why update strategy and union transformations are active?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What you know about transaction control transformation?
What is complex mapping?
What are the different components of powercenter?
What is option by which we can run all the sessions in a batch simultaneously?
Can we create multiple integration service on single repository?
How many ways are there to do 'remove duplicate records in informatica'?
Explain scd type 3 through mapping.
What is the difference between a connected look up and unconnected lookup?
How to generate sequence numbers using expression transformation?
What is domain in terms of informatica?