Answer / padmavathi

Mapping parameter represent a constant value that can be
defined before mapping run.
Mapping Variable represents a value that can be changed
during mapping run

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  

---

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

---

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,

---

what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,

---

what is meant by data driven.. in which scenario we use that..?

2 Answers   IBM,

---

---

what is INFORMATICA TESTING process

0 Answers  

---

How many repositories can we create in Informatica?

3 Answers  

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,

---

what is parameter file?

1 Answers   Cap Gemini,

---

What is resilience time?

0 Answers  

---

On which transformations you created partitions in your project?

0 Answers   Cap Gemini,

---

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

5 Answers   Cap Gemini,

---