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

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2181

---

What is a standalone command task?

1203

---

What is the command used to run a batch?

1062

---

What is rank transformation in informatica

1177

---

What is a filter transformation?

1042

---

Performance tuning in UNIX for informatica mappings?

2566

---

what is Active lock explain

2797

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2121

---

What could be the possible resons of locks by user?

1091

---

Describe an informatica powercenter?

1125

---

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

1126

---

Is it possible to create multiple domains on a single Informatica server?

1238

---

Design a mapping to load a target table with the following values from the above source?

1344

---

How can we update a record in the target table without using update strategy?

1142

---

How to update or delete the rows in a target, which do not have key fields?

1176

---