Answer Posted / davankumar

1st take squence t/t conn expresion t/r to one out put port.
In sequence t/r enable cycle option and start value is 1
end value is 3 and increment by 1.
then take rouder t/r in 1st group nextval/3=0 then 1st
target,nextval/3=1 then take 2nd target then connect to
default group ok.. r u clear...

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1061

---

How can you increase the performance in joiner transformation?

1155

---

What is the fact table?

1013

---

If informatica has its scheduler why using third party scheduler?

1221

---

What are the limitations of joiner transformation?

1064

---

I have a flat file, want to reverse the contents of the flat file

1078

---

What are the static cache and dynamic cache in informatica?

1154

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

933

---

In how many ways we can create ports?

1081

---

In informatica workflow manager, how many repositories can be created?

1297

---

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

4090

---

What is the need of etl tools?

1071

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2271

---

How to join three sources using joiner?

1052

---

Is it possible to define a single node as a Gateway node as well as worker node?

1077

---