Answer / lisa

I can add one dummy column to both the tables with value '1' and join both the tables on the basis of that dummy column. But how to do the join when there are huge number of columns/huge data volume in the tables? Please reply!

Can informatica load heterogeneous targets from heterogeneous sources?

0 Answers  

---

What is the status code?

1 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,

---

Router T/R is active but some people are saying it is also passive which is exactly right?

5 Answers  

---

how i will stop my workflow after 10 errors

2 Answers   HP,

---

In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data

2 Answers   HCL, Schneider,

---

Explain about Informatica server process that how it works relates to mapping variables?

0 Answers   Informatica,

---

what is bridge tables in informatica

1 Answers   CTS,

---

in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify

3 Answers   Patni,

---

i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,

---

Is there any target staging area in informatica not staging area

0 Answers   Syntel,

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

0 Answers   CTS,

---