Answer / kishor potu

ROWID is the pesudo column the oracle it can create in built. it is the hexa decimal data type(it contain alpha numaric number). it contain length is 18 digits. there ROWID in a table must be unique. if you drop the row the ROWID will remove. if any new record enter into the table ROWID assigns a unique number that record.
if you want to see the rowid
select rowid from table_name;

Answer / pullagura8

ROWID is the physical location of a row. Consequently it is the fastest way of locating a row

can be used COM component in Informatica ?

1 Answers  

---

Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

1 Answers  

---

Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?

5 Answers  

---

how to answer the question "explain project architecture" in informatica pls any one who has the answer pls send the answer to this mail id "karumanchisrinu@gmail.com

2 Answers   TCS,

---

what is the meant by Normalization and de-normalization?

1 Answers  

---

in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?

2 Answers   Accenture,

---

Give the benefits of data integration suite?

1 Answers  

---

what are the different forms of normalization?

2 Answers  

---

Difference between flat files and relational sources?

1 Answers   Satyam,

---

A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

1 Answers  

---

can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

1 Answers  

---

what are the data modeling tools you have used?(polaris)

0 Answers  

---