Answer Posted / abhishek kumar

step 1
if first row h as not null then we can use first()
function in aggregator T/F.

step 2
use sequence generator T/F And filter T/F write condition
nextval=1

What is the function of aggregator transformation?

1015

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2312

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2236

---

What are the restrictions of union transformation?

976

---

How to do unit testing in informatica?

1121

---

Where do we use mapping variables in informatica?

996

---

How is union transformation utilized?

948

---

What is pmcmd command?

1044

---

What is the way to execute pl/sql script using informatica mapping?

1507

---

Is it possible to define a single node as a Gateway node as well as worker node?

1057

---

What is the Rank index port in Rank transformation?

1011

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5561

---

What is primary and backup node?

1080

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

1025

---

What is a rank transform?

1024

---