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

How to load the data from a flat file into the target where the source flat file name changes daily?

1046

---

What are the components of the workflow manager?

1124

---

How to elaborate tracing level?

1164

---

What you know about transaction control transformation?

990

---

How to create Target definition for flat files?

1207

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1167

---

How does a rank transform differ from aggregator transform functions max and min?

1194

---

Describe expression transformation?

1112

---

What is the function of union transformation?

1122

---

How can you generate reports in informatica?

1016

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2113

---

How to load the data from people soft hrm to people soft erm using informatica?

1001

---

What do think which one is the better joiner or look up?

1196

---

What are the different types of olap? Give an example?

1041

---

What is Cognos script editor?

4211

---