Answer / pawan

Test Load is an option at session level.Enabling this option provides an option for debugging & dry run of informatica codes without any (impacts) commit in target tables. Number of rows for dry run/testing can also be specified .By default its 1.

Plz can any one say me how to get the informatica certification materials and dumps

0 Answers   TCS,

---

How to update records in Target, without using Update Strategy?

3 Answers  

---

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

---

disable caching in a lookup transformation?

1 Answers  

---

What is the difference between informatica 7.0 and 8.0?

0 Answers  

---

How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,

---

Repository user profiles

0 Answers  

---

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,

---

Explain the features of connected and unconnected lookup.

0 Answers  

---

How to retrieve last two days updated records?

4 Answers  

---

Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

1 Answers   IBM,

---

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,

---