two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .

2 Answers   TCS,

---

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

---

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,

---

Can we create a Integration service without a Repository service and vice versa?

0 Answers  

---

What is the difference Between Mapping parameter and variable

3 Answers   Accenture,

---

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,

---

How you count the number of records available at your source?

3 Answers   Zensar,

---

Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,

---

What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,

---

Why we use partitioning the session in informatica?

2 Answers  

---

why we need informatica

2 Answers   HCL,

---

Define informatica repository?

2 Answers   Wipro,

---