Answer / rkumar.etl

Unit testing in Informatica performed using ...

1)src qualifier query if providing us the final result
..with only calculating logic in between than ...test the
count results in sql navigator.

2)column to column mapping to make sure the result passing
to columns are correct.

3)data type mismatch or matched.

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,

---

In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

0 Answers  

---

How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,

---

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,

---

Without source how to insert record to target?

6 Answers  

---

What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,

---

Can you use one mapping to populate two tables in different schemas

2 Answers  

---

Can we create multiple integration service on single repository?

0 Answers  

---

what is diff between grep and find

3 Answers   IBM, iFlex,

---

Whats there in global repository

0 Answers  

---

How big was your fact table

0 Answers  

---