Answer / kishore

first of all Understanding Business requirements is the job of business analysts.
let the question was fired on the developer: then

First i will study the source system, and will try to figure out the business needs, if i didn't succeed in that, then i will discuss the issues with my business analysts.

source system study involves in understanding the relations between columns in a table, or fields in a flat file or data in a cobol file.

Answer / moorthy g

I'm working in Informatica support project:
In generally we say any new req. "ticket" Ex: INIT1113371
using this ticket no. we can able get the document through
remedy tool
and just go through the document and understand the
requirement. adding new column or remove column like that.
If we are removing any column means, first check it out
this column refered any table or not
after that only. we can remove the particular column.
adding new column is very easy. 1-1 mapping.
after finishing we prepare migration document. we will send
to customer for cutomer requirement.

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,

---

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

---

i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

1 Answers   Mind Tree,

---

what is dynamic cashe

3 Answers   Informatica,

---

what is the dashbords?

1 Answers   IBM,

---

What is deployemnt groups, Lables, query and dynamic deployment group.

1 Answers   IBM, SVP,

---

what is surrogate id ?

3 Answers   IBM,

---

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,

---

what is incremental aggregation ,with example?

2 Answers  

---

What are mapplets? How is it different from a Reusable Transformation?

0 Answers   Informatica,

---

How do you load alternate records into different tables through mapping flow?

0 Answers  

---

How to load only the first and last record of a flat file into the target?

3 Answers   Mind Tree,

---