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.

What did you do in source pre load stored procedure

1 Answers  

---

What is informatica? What exactly are the practical uses in real world

2 Answers  

---

What is predefined event?

1 Answers  

---

my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.

5 Answers   IBM,

---

hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,

---

Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

---

How do you create single lookup transformation using multiple tables?

6 Answers   TCS,

---

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,

---

What is update strategy transform?

0 Answers  

---

Mention some types of transformation?

0 Answers  

---

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

---

what is fact and what types of fact tables is there

4 Answers   Cap Gemini,

---