Answer / harish konda

1. Declare workflow and mapping variables and assign them in Pre and Post session.

2. Use Transaction control transformation to create the target files dynamically.

Like everytime you run the session you can create the target file with the value of mapping variable as a run number.

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

---

In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?

4 Answers  

---

By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,

---

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

---

suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?

3 Answers   TCS,

---

---

What are parallel querys and query hints?

1 Answers  

---

Why use shortcuts(Instead of making copies).

1 Answers  

---

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,

---

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

---

why union transformation is active transformation?

6 Answers   IndiGo, TCS,

---

Explain how to import oracle sequence into informatica?

0 Answers  

---

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

0 Answers  

---