Answer Posted / santosh

1.If you have duplicate data then you can use sorter or aggregator transformation to remove duplicate.
2. If u want to delete record after 50 the row then u can use sequence genetor.
3. Write the result to a other flat file as target.
4. Use 'Post session success command' in component tab of session task to delete the old flat file and rename the target flat file to old flat file.

Please correct me if this is wrong
Thanks and regards
Santosh Kumar Sarangi

What is sorter transformation?

1057

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2137

---

Scheduling properties,whats the default (sequential)

1965

---

How does a rank transform differ from aggregator transform functions max and min?

1213

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

2219

---

Define Pmrep command?

1072

---

draw informatica architecture 8.6 ?

3879

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4117

---

What are the tasks that can be performed using sq?

1100

---

What are the components of Informatica? And what is the purpose of each?

1062

---

Can you generate sequence numbers without using the sequence generator transformation?

1127

---

How to open an older version of an object in the workspace?

1209

---

Explain incremental aggregation in informatica

1141

---

Enlist the differences between database and data warehouse.

1127

---

How to partition the Session?

1119

---