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
EXL informatica Questions
Implementation methodology
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How to use pmcmd utility command?
Is it possible to use a client with different version than that of its Informatica server?
Design time, run time. If you don't create parameter what will happen
What is sq transformation?
Is there any way to read the ms excel datas directly into informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Separate from an archive server and a powerhouse?
Explain how to import oracle sequence into informatica?
How many types of sessions are there in informatica.please explain them?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Differentiate between Load Manager and DTM?
How to improve the performance of a session using sorter transformation?