Can we create a Integration service without a Repository service and vice versa?

0 Answers  

---

What is a repository? And how to add it in an informatica client?

0 Answers   Informatica,

---

split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

1 Answers   Cap Gemini, TCS, Wipro,

---

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  

---

why dimenstion tables are denormalized in nature ?

3 Answers  

---

How to delete the data in the target table after loaded.

3 Answers   TCS,

---

why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,

---

what is update strategy transformation ?

7 Answers   TCS,

---

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,

---

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh

4 Answers   Accenture, TCS,

---

how can we calculate fact table size?

1 Answers  

---

How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,

---