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
- 11430 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
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Why do we need informatica?
What is main use of mapplet?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
how many types of dimensions are available in informatica?
Can you use flat files in Mapplets.
In development project what is the process to follow for an etl developer from day1
What is an unconnected transformation?
How do you promote a non-reusable transformation to reusable transformation?
Design a mapping to load a target table with the following values from the above source?
r u done any partitions in ur project?
Define pmcmd command?
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
What the difference is between a database, a data warehouse and a data mart?
Which files are created during the session rums by informatics server?
