Answer / rao

normalizer transformation.which will performs normalized data.
ex:year q1 q2 q3
2006 10 20 30
2007 20 30 40
after performing the normalizer transformation the date
will be like this
year item sales
2006 1 10
2006 2 20
2006 3 30
like 2007 also

Answer / informatica_learner

upstare,Rao
this only use one nomalizer transformation
configure one item as occurs 3 is ok
it is easy

Answer / ram kumar

SCD 2 is one of the complecated mapping in informatica

i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

6 Answers   IBM,

---

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,

---

What is target update override

2 Answers   CTS,

---

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

0 Answers  

---

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,

---

I have 1200 records how can u send it in aggregator with good performance issues?

3 Answers  

---

tell me the push down optimization

2 Answers   Wipro,

---

what is confirmed dimension?

6 Answers  

---

What are the types of data warehouses?

0 Answers   Informatica,

---

why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,

---

how tokens will generate?

0 Answers  

---

What is difference between stored procedure transformation and external procedure transformation?

2 Answers  

---