Answer Posted / guest

it is not possible to take data from 11th records. because
consider this senario.. if u give select statement as
select column name1,2.... from table name where rownum<5;

this select statement wil work if u have 10 or more than 5
records in table.

now u r asking to load only from 11th record

so the query will be like this

select column name1,2,.... from table name where rownum>10;

it wil return emptyset only..

see the checking condition. it wil fetch the 1st record and
check rownum 1 > rownum 10. condition failed. so it wont go
to second record and results in empty set.

but in earlier case it wil fetch 1st record and checks
rownum 1 < rownum 5. condition satisfied. it wil load that
row and check for 2nd row and 3rd and so on until the
condition fails.

once the condition fails it wil come out.

How can we delete duplicate rows from flat files?

1231

---

How many input parameters can exist in an unconnected lookup?

1550

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

2310

---

What is the function of union transformation?

1139

---

What is meant by target load plan?

977

---

what are 3 tech challenges/ common issues you face?

2348

---

What are the reusable transformations?

1170

---

Explian the Process of deployment groups in informatica

1064

---

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 ?

2370

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2038

---

What is a transaction control transformation?

1213

---

What is rank index in rank transformation?

1082

---

Can you use flat files in Mapplets.

2656

---

What is an unconnected transformation?

1089

---

What is a surrogate key?

1088

---