Answer / rajesh kumar

We can create mapping parameters and variables in mapping designer/mapplet designer.
We can define the value within the transformation

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

---

What is the difference between procedure and stored procedur?

2 Answers   IBM,

---

Under which circumstances, informatica server creates reject files?

0 Answers   Informatica,

---

What are the types of maping in Getting Started Wizard?

1 Answers  

---

---

Define update strategy?

0 Answers  

---

explain about informatica server architecture?

1 Answers   IBM,

---

source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

4 Answers   TCS,

---

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.

3 Answers   Wipro,

---

How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?

10 Answers   Wipro,

---

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

---

we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,

---