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

What is target designer and target load order?

1088

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2728

---

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

1072

---

Can informatica load heterogeneous targets from heterogeneous sources?

1172

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1769

---

Explain about cumulative Sum or moving sum?

1016

---

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

1738

---

What is the advantage of informatica?

1051

---

What is joiner change?

1131

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2300

---

what is size of u r database?

2290

---

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

1057

---

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

1459

---

Explain informatica architecture - version 8 / 9

1068

---

What is the use of code page?

1065

---