Answer Posted / ganesh kumar

BY USING QUERY OVERRIDE IN SOURCE QUALIFIER
TO WRITE THE QUERY LIKE THIS

T_TEST UR SOURCE TABLE, NAME AND N_NUMBER UR SOURCE TABLE
COLUMN.

USING THE LEVEL PSEUDOCOLUMN TO GENERATE THE DUMMY ID(LEVEL
L)AND USING THE QUERY(DUAL TABLE) AS A INLINE VIEW AND THEN
JOIN(NON EQUIJOIN) THE CONDITION. FINALLY WE GOT THE RESUL

select t.name,t.n_number from t_test t,(select level l from
dual connect by level <= (select max(n_number) from t_test))
u where t.n_number>=u.l order by t.name;

SAME LOGIC USED FOR OTHER THAN RELATIONAL SOURCE AND THE
TRANSFORMATION.

Repository user profiles

1763

---

Explain constraint based loading in informatica

1096

---

What is Session and Batches?

1108

---

Different qualification between a related rotate toward the sky and isolates look upward?

989

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1283

---

How many dimensions are there in informatica?

1091

---

Performance tuning in UNIX for informatica mappings?

2568

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1130

---

How can repository reports be accessed without sql or other transformations?

1220

---

Did u used latest transformations of 8.6.0? for what?

1882

---

How to load a Dimension ? and how to load a fact table?

1419

---

What are the different options available for update strategy?

1004

---

How to start a workflow using pmcmd command?

1253

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2134

---