Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 11248 Views
- I also Faced
- E-Mail Answers
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
How can we create index after completion of load process?
How to start a workflow using pmcmd command?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How to do unit testing in informatica? How to load data in informatica ?
what are the Methods For Creating Reusable Transformations?
Partition, what happens if the specified key range is shorter and longer
While migrating the data from one environment to another environment how would you manage the connections?
Differences between version 7.x and 8.x.
what are 3 tech challenges/ common issues you face?
Is there any way to read the ms excel datas directly into informatica?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is an unconnected transformation?
How do you load unique records into one target table and duplicate records into a different target table?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
