Answer / ritu

Just right Click on the session and choose the option of
start the workflow from task.Need not to run the whole wf.

Answer / sunil

You can do it by copying the required session and pasting it
in the workflow. You need not have to promote the work flow.

Answer / manu

Lets say you want to promote from DEV to QA.
wf1 - s1, s2, s3
and you want to promote only s2

Export the xml (rep manager) from dev and import in qa .
While doing the import, select "reuse" for s1 and s3 and for
s2 use "replace"

Answer / nirakar jena

No You cant promote the session.You can promote if it is a
reusable else promote the whole wotkflow.

what are the output files that the informatica server creats during running a session?

2 Answers   CTS,

---

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 ?

0 Answers   IBM,

---

while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,

---

In ur current projectu have done any performance tuning of mappings?

1 Answers  

---

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,

---

---

Why use the lookup transformation ?

2 Answers   Informatica,

---

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

---

in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?

3 Answers   Thomson Reuters,

---

What is sequence generator transformation in informatica?

0 Answers  

---

What happens if we dont select data driven option?

2 Answers   Zensar,

---

Could any one to tell Fact table Partitioning?

2 Answers  

---

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  

---