Answer Posted / sbvp

hi raj

when we use source as a flat file
if a flat file contians 10 records assume ok
take seq gen t/r- next val
to exp t/r
in that add a new port and give seq gen-nextval to that new
port(suppose call as seq_num ok)

take RTR t/r
create two out ports ok
seq_num<=5
seq_num>=5
contect to two tgrts ok


thanks
sbvp

Design a mapping to load a target table with the following values from the above source?

1352

---

what is unit testing?tell me proceedure

2229

---

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

1761

---

How identifying bottlenecks in various components of informatica and resolving them?

1138

---

Under which circumstances, informatica server creates reject files?

1102

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1514

---

What do you mean by worklet?

1076

---

Explain constraint based loading in informatica

1103

---

If informatica has its scheduler why using third party scheduler?

1272

---

How to delete duplicate row using informatica?

1051

---

Explain the informatica workflow?

1075

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1163

---

What are the new features of informatica 9.x developer?

972

---

How many input parameters can exist in an unconnected lookup?

1551

---

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

1027

---