Answer / meera

creating copies takes extra memory. it is anlaogus to have a complete duplicate of the mapping. whereas shortcut refers to the refrence for the mapping. when creating shortcut memory is not used up . and any change made to the original reference (mapping) will be reflected in the shortcut.

If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers   TCS,

---

What is the Hierarchy of DWH?

1 Answers  

---

What is partioning?how many types of partinings are there

2 Answers   HCL,

---

why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,

---

Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

---

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,

---

What is a shortcut and copy in Informatica and how two are different with each other?

0 Answers  

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

0 Answers   Informatica,

---

What are the basic needs to join two sources in a source qualifier?

4 Answers  

---

write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

3 Answers   Cognizant, Flextronics,

---

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

---

I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?

1 Answers  

---