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

Where can we find the throughput option in informatica?

1107

---

According to his methodology what all you need before you build a datawarehouse

1801

---

r u done any partitions in ur project?

1863

---

What is the meaning of up gradation of repository?

2052

---

What do you mean incremental aggregation?

1130

---

What is target load order?

1298

---

Explain the difference between a data warehouse and a data mart?

1111

---

Write the unconnected lookup syntax?

1131

---

Reusable transformation and shortcut differences

1880

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2193

---

lookup transformation with screenshots

4050

---

If informatica has its scheduler why using third party scheduler?

1307

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1128

---

What is resilience time?

1227

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2290

---