Answer Posted / star

Not sure if this has to be solved by SQL or by informatica -
and source is a table or file.

select * from (select lead(gender,0,0) over (partition by
gender), lead(gender,1,0) over (partition by gender) from
table1) where rownum=1
union all
select t1.name, t2.name from
(select name,row_number() over (partition by name) from
table1 where gender='male') t1,
(select name,row_number() over (partition by name) from
table1 where gender='female') t2
where
t1.name(+) = t2.name(+)

What is workflow monitor?

1062

---

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

1178

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1080

---

How many types of sessions are there in informatica.please explain them?

1169

---

How do you migrate data from one environment to another?

1095

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1085

---

Explain the types of lookup transformation?

1045

---

What are roles and groups and benefits of using them?

1057

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1767

---

What is standalone command task?

1318

---

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

1003

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1091

---

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

1059

---

While migrating the data from one environment to another environment how would you manage the connections?

1090

---

How to create the source and target database connections in server manager?

1090

---