Answer / sreedhar lokaray

Refer the topic Reject Files in the Informaitca Guide.

What is difference between partioning of relatonal target and partitioning of file targets?

2 Answers  

---

Define filter transformation?

0 Answers  

---

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,

---

what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram

3 Answers  

---

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers   HCL,

---

---

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,

---

What is the commit type if you have a transaction control transformation in the mapping?

0 Answers   Informatica,

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers   Informatica,

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

0 Answers  

---

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

0 Answers  

---

,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

3 Answers   Emphasis,

---