Answer Posted / venkat

Yes, we can get first record using aggregator below are the
steps:
First need to sort all the records by desc and connect to
aggregator transformation than connect to target without
using gropby port than you will get first record.

Ask me any questions to <ittoolboxdwh@gmail.com> this is my
mailid.

Cheers
Venkat.

How might you approve all mappings in the archive all the while?

968

---

What are mapplets?

1220

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1439

---

What is dynamic cache?

984

---

What is event and what are the tasks related to it?

1072

---

What are the new features of Power Center 5.0?

1714

---

what is the -ve test case in your project.

2351

---

Can we create two repositories on same database instance in oracle?

1040

---

can anyone suggest best free Talend data integration training online

1638

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2010

---

What is sq transformation?

1091

---

Define Pmrep command?

1006

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1066

---

What is a surrogate key?

1027

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1590

---