Answer Posted / venu

s----sq------srt----rtr---t1
t2

inthis flow take two sequence generaters and connect to
s0rter t/f like this

nextvalue descending order enable
nextvalue1 asending order enable

for example if 6 records contain
the sort result would be

nextvalue nextvalue1
6 1
5 2
4 3
3 4
2 5
1 6

sorter contain these ports and remaing ports next pass these
ports to ruter t/f

nextvalue > nextvalue1 1st condition ---it give 1st 3rows
nextvalue < nextvalue1 2nd cond ---- it gives last 3 rows

During the running session, output files are created by informatica server. Enlist few of them.

927

---

EXL informatica Questions

1309

---

Quickly characterize reusable change?

1057

---

What is incremental aggregation?

1011

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1905

---

How does a sorter cache works?

999

---

Describe the impact of several join conditions and join order in a joiner transformation?

1006

---

How to create a non-reusable instance of reusable transformations?

1057

---

How does the aggregator transformation handle null values?

1084

---

What are the advantages of using informatica as an etl tool over teradata?

968

---

What is persistent lookup cache?

965

---

Can we get 1st record through Informatica(without sequence number).

1398

---

What do you mean by filter transformation?

900

---

How to improve the performance of a session using sorter transformation?

1090

---

How to call shell scripts from informatica?

933

---