Answer Posted / sagarreddy

in source qualifier your using this query like this u get it
easily
select rowid from tablename
minus
(select min(rowid) from tablename
union
select max(rowid) from tablename )
if u write this query will work it plz go through it

can we override a native sql query within informatica? Where do we do it? How do we do it?

1055

---

How many ways a relational source definition can be updated and what are they?

1017

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1664

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2036

---

What all join we can perform in LOOKUP transformation?

978

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1105

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2037

---

If informatica has its scheduler why using third party scheduler?

1268

---

What you know about transaction control transformation?

996

---

How to load data in informatica ?

1021

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1963

---

How to update or delete the rows in a target, which do not have key fields?

1178

---

Define pmcmd command?

1047

---

Tell me about Propagate functions in informatica

922

---

What is difference between a gateway node and worker node?

1141

---