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

In development project what is the process to follow for an etl developer from day1

1727

---

differences between service based and product based?

2021

---

Define sessions in informatica etl?

1042

---

Is there any target staging area in informatica not staging area

2582

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2260

---

Explain informatica architecture - version 8 / 9

1102

---

What is meant by active and passive transformation?

1137

---

Tell me about MD5 functions in informatica

933

---

what is the size of u r source(like file or table)?

2278

---

Explain the aggregator transformation?

1174

---

What are the differences between source qualifier and joiner transformation?

1070

---

Have you worked with/created Parameter file

1668

---

Is it possible to create multiple domains on a single Informatica server?

1251

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1290

---

scenario where i can use only concurrent execution of workflow.

3184

---