Answer / krishnakanth.ch

I think as we move into the future, the historical data
size increases which impacts the performace for complex
calculations or aggregations. Which also impacts at report
level to drill down.

Answer / srinu

Doveloping Programing tools also

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,

---

List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  

---

How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

2 Answers   IBM,

---

what is metadata?

6 Answers  

---

Separate from a database, an information bazaar, and an information stockroom?

0 Answers  

---

What is a data modeling?

2 Answers  

---

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

2 Answers   Mphasis,

---

my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced

9 Answers  

---

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

---

If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?

6 Answers  

---

which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,

---

can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,

---