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

Can you generate sequence numbers without using the sequence generator transformation?

1061

---

What is persistent lookup cache?

976

---

What is the difference between stop and abort in informatica

1050

---

How to use pmcmd utility command?

980

---

what is diff b/t sorter t/r and agg have the option sorter property...

2138

---

How do you promote a non-reusable transformation to reusable transformation?

1078

---

How many number of sessions can one group in batches?

1109

---

Explain sessions. Explain how batches are used to combine executions?

960

---

Explain about cumulative Sum or moving sum?

989

---

How can you validate all mappings in the repository simultaneously?

1303

---

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

1299

---

What is the advantage of informatica?

1020

---

How to join three sources using joiner?

1042

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1851

---

waht type of interface is used for testing the data in informatica

2202

---