Answer Posted / ajit kumar pradhan

if it is a relational source then click on source Qualifier
properties then check Distinct option.

if it is a flat file then it can't work .......

click on target defination select target menu and click
generate/execute then it come out one dialog box come out
then check primary key check box..it avoid duplicale row...

Different sorts of metadata that stores in the storage facility?

960

---

What is a mapplet/worklet in informatica?

1134

---

expain about the tune parameters?

2347

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1517

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1939

---

What is intricate mapping?

1104

---

What is Data Caches size?

1044

---

Write the advantages of partitioning a session?

1222

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2306

---

What is rank index in rank transformation?

1016

---

Where do we use mapping variables in informatica?

1004

---

Explain constraint based loading in informatica

1048

---

How to handle decimal places while importing a flatfile into informatica?

1140

---

Explain the mapping variable usage example in informatica

1094

---

What is a filter transformation and why it is an active one?

917

---