Answer / sreedhar lokaray

Refer the topic Reject Files in the Informaitca Guide.

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

1 Answers   IBM,

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

0 Answers  

---

How do you implement scheduling in Informatica?

1 Answers  

---

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

---

What are the different ways to implement parallel processing in informatica?

0 Answers  

---

Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers  

---

What are active transformations.

0 Answers  

---

Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,

---

draw informatica architecture 8.6 ?

0 Answers   Cognizant, TCS,

---

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  

---

how to improve performence by using sorted input in aggrigator t/r.

2 Answers  

---