Answer / giri

Sorter Aggregator
------- -----------
1.Asc and Desc Only Asc order purpose
order purpose
2.Query is not Passible query is passible

Answer / dkr

Sorter uses the sorter Algorithm, but Aggrigator uses a
physical Algorithm -(called CLUSTERED Algorithm)

Explain pmcmd command usage in informatica

0 Answers   Informatica,

---

my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

2 Answers   Zensar,

---

get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

3 Answers   Infosys,

---

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,

---

What is target load order?

0 Answers  

---

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,

---

what is size of u r database?

0 Answers  

---

why cant we put a sequence generator or upd strategy transformation before joiner transformation?

2 Answers   Satyam,

---

what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

---

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,

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,

---

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  

---