Answer Posted / dheeraj patidar
ur calculate size of data base in oracle
select sum(bytes)/1024/1024 from dba_data_files;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Enlist the differences between database and data warehouse.
How to load last n records of file into target table - informatica
What is the cumulative sum and moving sum?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Write the unconnected lookup syntax?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Reusable transformation and shortcut differences
What is a repository? And how to add it in an informatica client?
Is it possible to create multiple domains on a single Informatica server?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
difference between repository database and repository service?
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
Define update strategy?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?