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.

How union transformation is active ?

2 Answers   Puma,

---

can you please explain me pre session and post session options?

3 Answers   BTBP,

---

What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,

---

what is the incremental agrrigation?

2 Answers   Cap Gemini,

---

how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,

---

Differentiate between reusable transformation and mapplet.

0 Answers  

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

0 Answers   CTS,

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

Can we update the data in flat file using update strategy?

3 Answers  

---

Mention few advantages of router transformation over filter transformation.

0 Answers  

---

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

---

I need an oracle query for convert Char to Integer?. Can any one help me how to do this?

3 Answers  

---