Answer / tadikonda

if u have toad, u can find the tool option tab under that
ESTIMATE TABLE SIZE option,in that u can define the table
name and schema name ,in that way u can find which table is
big in size

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,

---

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

0 Answers  

---

Can you start a batches with in a batch?

1 Answers  

---

How will you convert rows into columns or columns into rows

1 Answers  

---

---

Difference between Target-based loading and constraint-based loading?

0 Answers  

---

source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers   Polaris,

---

What is domain in terms of informatica?

0 Answers  

---

Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

1 Answers   IBM,

---

can we create index and drop index in exsisting table while using infomatica

4 Answers  

---

what is the size of your data warehousing?

0 Answers   IBM,

---

While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  

---