Answer / elango

It depends on the complexity of resuablity or re-mapping
based on the client specification.

So this question is to check whether r u smarter enough to
understand the existing mapping and design new ones.

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 Answers  

---

What are the designer tools for creating transformations?

0 Answers   Informatica,

---

 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,

---

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 u give example for factless fact table

2 Answers   TCS,

---

What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 Answers  

---

source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?

5 Answers   Polaris,

---

Describe two levels in which update strategy transformation sets?

1 Answers  

---

Why the UNION TRANSFERMATION is an Active TRANSFERMATION

6 Answers   Emphasis,

---

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  

---

Where do you create/define mapping parameter and mapping variable?

1 Answers  

---

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

0 Answers  

---