Answer Posted / krishnakanth.ch

yes... add a new column in the sql override by calculating
the count(*) to get how many times the record is repeating.
Using Router we can seperate them into two different
targets.

Under which circumstances, informatica server creates reject files?

1026

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2237

---

generate date / time dimension in informatica

1069

---

Differentiate between a database and data warehouse?

1090

---

Where do we use mapping variables in informatica?

996

---

Differentiate between reusable transformation and mapplet.

1028

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1112

---

What are the static cache and dynamic cache in informatica?

1139

---

What are the different transaction levels available in transaction control transformation?

1119

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3649

---

What is flashback table ? Advance thanks

1872

---

Difference between Data and Index Caches?

1091

---

How to do unit testing in informatica?

1122

---

What is informatica metadata and where is it stored?

932

---

What is olap (on-line analytical processing?

1007

---