Answer / sanjay

Informatica issue a status code when it's run the stored
precedure transformation , it is use for error handling of
store procedure .

Answer / usha

Status code provides error handling facility.

What are the out put files that the informatica server creates during the session running?

2 Answers  

---

can u any challenge your project?

0 Answers   HP,

---

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

1 Answers   TCS,

---

Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

0 Answers  

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

0 Answers  

---

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers  

---

when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,

---

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

---

What is difference between partioning of relatonal target and partitioning of file targets?

2 Answers  

---

What are Target Options on the Servers?

1 Answers  

---

list out all the transformations which use cache?

0 Answers   Informatica,

---

what is a transforamation?

5 Answers  

---