Answer / abhishek.x.upadhyay

A lookup with Dynamic cache can be replaced by an SQL
override query in the transformation itself which will run
each time there is load of data during the run of the
Workflow.

Answer / qamar

I suppose the answer to this question is by using Joiner
transformation.

I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..

2 Answers   DELL,

---

What is difference macros and prompts?

2 Answers  

---

What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?

5 Answers   TCS,

---

what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,

---

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

---

How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers   TCS, Tech Mahindra,

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,

---

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers  

---

how can one eliminate dupliacte data with out using distinct option?

5 Answers   Patni, Wipro,

---

one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,

---

What is degenerated dimention table?

7 Answers   Patni,

---

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

0 Answers  

---