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
- 9780 Views
- I also Faced
- E-Mail Answers
Answer Posted / rakesh
if source n targer exist in
different databases you can
create Database link in any of
the database for other one..
create database link "dblink
name"
connect to schemaname
identified by password
using 'Database name';
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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 ?
Separate from a database, an information bazaar, and an information stockroom?
What is workflow? What are the components of workflow manager?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Is it possible to define a single node as a Gateway node as well as worker node?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
EXL informatica Questions
What is joiner change?
What are the different clients of powercenter?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Can informatica load heterogeneous targets from heterogeneous sources?
What is incremental aggregation?
What is target load order?
wat are deployement groups in informatica, how it will be used for developers
Define joiner transformation?
