Answer Posted / amedela chandra sekhar

BY USING NORMALIZER T/R WE CAN ACHIEVE THIS SCENARIO.








I hope i have given right solution.

Which transformation should we use to normalise the COBOL and relational sources?

1182

---

What is a filter transformation?

1024

---

design of staging area?

2015

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1774

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1116

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2113

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2228

---

How to create the source and target database connections in server manager?

1071

---

How can we delete duplicate rows from flat files?

1204

---

What is confirmed fact in dataware housing?

6929

---

Describe an informatica powercenter?

1108

---

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

2336

---

What do you mean by blocking transformation?

1015

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1089

---

What are the differences between joiner transformation and source qualifier transformation?

1148

---