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

Under what condition selecting sorted input in aggregator may fail the session?

1108

---

How can you generate reports in informatica?

1004

---

How to partition the Session?

1084

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1952

---

without table how to come first record only in oracle?

2233

---

Make a note of the quantity vaults made in informatica?

969

---

What does reusable transformation mean?

1115

---

Explain why we use partitioning the session in informatica?

1068

---

Explain in detail about scd type 1 through mapping.

1403

---

What is complex mapping?

1105

---

Explain the different kinds of facts.

970

---

Quickly characterize reusable change?

1091

---

Why do you use Mapping Parameter and mapping variable?

1740

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2247

---

How many numbers of sessions can one group in batches?

1051

---