Answer Posted / murali udayagiri

Use join UNIX command in pre-session command for joining
both the files and write to a file. Use single SQ trans in
mapping to read that joined flat file data.



Thanks,
Murali Udayagiri

Make a note of the quantity vaults made in informatica?

938

---

What are the guidelines to be followed while using union transformation?

1062

---

What is a connected transformation?

1042

---

Why sorter is an active transformation?

1124

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2304

---

How to use procedural logic inside infromatica?

1132

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1789

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1021

---

What is target load order?

1184

---

What's the layout of parameter file (what does a parameter file contain?)?

2331

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9735

---

Explain sql transformation in script mode examples in informatica

1043

---

Explain the types of lookup transformation?

977

---

Define mapplet?

959

---

What is meant by a domain?

1077

---