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

Briefly describe lookup transformation?

1002

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8158

---

What are the guidelines to be followed while using union transformation?

1097

---

What is fact table? Explain the different kinds of facts.

1033

---

Differentiate between router and filter transformation?

971

---

How can we remove the duplicates from flat file source?

974

---

Why union transformation is an active transformation?

1011

---

What is an expression transformation?

983

---

what is the Default Source Option For Update Strategy Transformation?

1192

---

can u any challenge your project?

1984

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

994

---

State the limitations where we cannot use joiner in the mapping pipeline?

1017

---

What are the tasks that source qualifier perform?

1055

---

Target increases every day even though no new record was inserted

1529

---

What is standalone command task?

1282

---