Answer Posted / sandya

hi
if it is excel sheet, save as in CSV format, while importing
csv file in informatica designer, check 'Singlequotes' under
Text qualifier. it separates as both city and state in to
two columns which is in one column. after that double quotes
appear on the top of city and column. we can remove using
trim.previously i have tried this and got result.

Enlist the differences between database and data warehouse.

1096

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1095

---

Explain the different kinds of facts.

970

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1058

---

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

1064

---

Describe an informatica powercenter?

1107

---

permutations of mapplet

2489

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1474

---

where to store informatica rejected data? How to extract the informatica rejected data?

984

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2179

---

What are some examples of informatica etl programs?

917

---

Define Pmrep command?

1031

---

What is the benefit of session partitioning?

1096

---

What is the need for an etl tool?

1053

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1897

---