Answer Posted / deepak aggarwal

No there is no option in informatica for automatic update
of source/target/lookup/stored procedure definition from
DB/file.
Though you can compare source/target/../.. definitions from
existing DB objects and make out if informatica definitions
needs a updation.

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

4168

---

whats the logic to load the lower level of granularity of data to fact table.

2279

---

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

1117

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1935

---

How can you define user defied event?

1036

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1173

---

permutations of mapplet

2514

---

What is a rank transform?

1093

---

Differentiate between joiner and lookup transformation?

1109

---

What is sequence generator transformation in informatica?

1086

---

what are 3 tech challenges/ common issues you face?

2350

---

Explain incremental aggregation in informatica

1141

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5689

---

What does “tail –f” command do and what is its use as an Informatica admin.

1116

---

What is native users?

1174

---