Answer Posted / leo gilbert

Say your input is VAR1 which are a1 and 1a.

Have an expression transformation to create two more
variables VAR2 and VAR3 out of VAR1 using the SUBSTR
function.
VAR2 = SUBSTR(VAR1,1,1) and VAR3 = SUBSTR(VAR1,2,1).
For VAR1=a1, VAR2=a and VAR3=1
VAR1=1a, VAR2=1 and VAR3=a

Pass VAR2 and VAR3 to the router. Have one output group
with condition IS_NUMERIC(VAR2) and the other obviously is
the default group. For the first group connect VAR2 to ID
of target and VAR3 to NAME of target. For default connect
VAR2 to NAME and VAR3 to ID

Output
=====
ID NAME
= =====
1 a
1 a

Suppose we do not group by on any ports of the aggregator what will be the output?

1041

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1133

---

How can a transformation be made reusable?

1168

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7065

---

What is a joiner transformation?

996

---

How to load data in informatica ?

1021

---

What is session task and command task?

1297

---

What is data transformation manager process?

1157

---

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

4160

---

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

1107

---

What is union transformation?

965

---

what is the -ve test case in your project.

2407

---

How to join three sources using joiner? Explain though mapping flow.

1147

---

What do you mean by enterprise data warehousing?

1065

---

What is a grid in Informatica?

1070

---