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

Suppose we do not group by on any ports of the aggregator what will be the output?

982

---

What is domain in terms of informatica?

952

---

What are mapplets? How is it different from a Reusable Transformation?

1032

---

What are the types of data warehouses?

1425

---

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

2266

---

Under what condition selecting sorted input in aggregator may fail the session?

1057

---

What does refresh system mean, and what are its distinctive choice?

1072

---

Explain why we use partitioning the session in informatica?

1006

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2073

---

What is the need of an ETL tool?

1027

---

Difference between Target-based loading and constraint-based loading?

944

---

What is a node in Informatica?

1002

---

What are roles and groups and benefits of using them?

989

---

What is aggregate cache in aggregator transformation?

1061

---

Is there any way to read the ms excel datas directly into informatica?

978

---