Answer Posted / srikanth

select * from table where rownum<=30

minus

select * from table where rownum<=21;

If informatica has its scheduler why using third party scheduler?

1193

---

Explain sessions?

979

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1033

---

What is option by which we can run all the sessions in a batch simultaneously?

1079

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1603

---

What is the Rank index port in Rank transformation?

1012

---

Tell me about Propagate functions in informatica

874

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1220

---

Do you find any difficulty while working with flat files as source and target?

1051

---

Mention some types of transformation?

991

---

What are the tasks that source qualifier perform?

1030

---

How to generate sequence numbers?

1029

---

What is Cognos script editor?

4163

---

What are the tasks that can be performed using sq?

1024

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2094

---