Answer / rao

THE BEST EXAMPLE IS SCD-1

Answer / abhinaw prakash

when you use dynamic lookup t/r a new row will be added to the lookup(lookup row port).
Use a router for insert and update.
have 2 update strategy t/r and give the xpression lookuprow port as 1(insert) and 2(update).
connect it to the target.

Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

10 Answers   CSC,

---

CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  

---

What is Datadriven?

2 Answers   Informatica,

---

what is left outer join?

3 Answers   L&T,

---

What is the difference between a repository server and a powerhouse?

0 Answers  

---

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

---

What is the difference between stop and abort in informatica

0 Answers   Informatica,

---

How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size

1 Answers  

---

What is joiner transformation in informatica?

0 Answers  

---

4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,

---

Stage is which type of load is it a full load or incremental load Please let me know in detail with best example

3 Answers   Infosys,

---

how to work with mapplet designer in informatica?

7 Answers  

---