Answer / sanjay

Target option for flie: FTP, LOADER, MQ
For Relational : Oracle, Teradata, sybase, Informix etc.

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers   IBM,

---

what is incremental aggregation ,with example?

2 Answers  

---

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,

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

0 Answers   Patni,

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

0 Answers  

---

Informatica settings are available in which file?

0 Answers   Informatica,

---

what is the diff b/w target load plan and cbl?

3 Answers   CTS, iGate,

---

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

---

Enlist some properties of sessions.

0 Answers  

---

Can we have a Mapping without a Source Qualifier?

14 Answers   Deloitte,

---

have you developed documents in your project? and what documents we develop in realtime?

2 Answers   IBM,

---

How identifying bottlenecks in various components of informatica and resolving them?

0 Answers  

---