Why touse stored procedure in ETL Application?

2 Answers  

---

If informatica has its scheduler why using third party scheduler?

0 Answers  

---

in a table it has 200 rows the query is select 150 from tablename.whats the output

2 Answers   Cap Gemini,

---

we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,

---

After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

3 Answers   TCS,

---

what is the monster dimension plz give me one example

2 Answers   EDS,

---

Explain the difference between mapping parameter and mapping variable?

0 Answers  

---

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000

7 Answers   Deloitte,

---

Why union transformation is an active transformation?

0 Answers   Informatica,

---

when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,

---

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,

---

Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,

---