Answer Posted / bsgsr

send the flat file data into an expression transformation
and create a new pory say xyz and connect nextval mport on
seq_gen to this. then connect expression to router take two
groups. using the nem port created write conditions.
newport<5 in first group ice versa. i believe this would
work

What is the procedure for creating independent data marts from informatica 7.1?

1117

---

What are batches?

1186

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1687

---

Implementation methodology

1770

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

1139

---

Explain how many types of dimensions are available in informatica?

1169

---

Is it possible to define a single node as a Gateway node as well as worker node?

1184

---

Please let me know how to make Data masking in informatica..

1772

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1334

---

What are the differences between source qualifier and joiner transformation?

1135

---

Explain constraint based loading in informatica

1152

---

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??

1111

---

How can we handle two sessions in informatica?

1092

---

Explain the tuning lookup transformation - informatica

1043

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1141

---