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

What is rank transform?

1061

---

What is mapping debugger?

1069

---

What is Cognos script editor?

4290

---

What is joiner transformation in informatica?

1101

---

Please let me know how to make Data masking in informatica..

1776

---

Enlist the tasks for which source qualifier transformation is used.

1075

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1858

---

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?

1021

---

write a query to retrieve the latest records from the table sorted by version(scd)

1122

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1960

---

Write the unconnected lookup syntax and how to return more than one column.

1150

---

What are the different options available for update strategy?

1054

---

What is transformation?

1159

---

How might you approve all mappings in the archive all the while?

1085

---

How to configure mapping in informatica?

1225

---