Answer Posted / srinu

I have an IDEA,
After sql Trans,go with AGG,RANK transformation,
in RankTrans Properties set the rank 1 only---1 row returns,
In AggTrans Dont do any column for Group--Last row returns,
We need 2 Target tables. 1 for 1st record,2 for last record,
if u using the UNIONtrans one Target table is enough,,,
i think it wii help u,,,,,,srinu,,,,,,,,,

What is exclusive and normal mode for repository services?

1146

---

How does the aggregator transformation handle null values?

1150

---

What is a node in Informatica?

1045

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1641

---

Informatica settings are available in which file?

992

---

Describe an informatica powercenter?

1127

---

Differentiate between a database and data warehouse?

1147

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2061

---

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

2125

---

Which is the t/r that builts only single cache memory?

1190

---

What is informatica etl tool?

1001

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1080

---

What are the differences between a connected lookup and unconnected lookup?

1070

---

explain about unit testing? in real time?

2209

---

How many ways are there to do 'remove duplicate records in informatica'?

1018

---