Answer / vijaya

by using normalizer transformation we can done it.

sq-> ex,-> norm-> tgt

if you want clear answer u check tmrw this question

Answer / rakesh

Thanks Vijaya.
In Expression we can use the date function to find the week number of the year. But here we have 1-nov-2011 as the column name, but not the column value. i.e; we have dates as column names, not as col values..
So please clarify..

Answer / yamini

Hi,

we can pass the date values in mapping parameter. why because as the column values are constant so we can pass that values in expression by creating output ports.

So after exp transformation put a normalizer with occurrence 2. after normalizer put an exp to convert date into week by to_char function

Where do you create/define mapping parameter and mapping variable?

1 Answers  

---

What is a code page?

0 Answers  

---

How is union transformation utilized?

0 Answers  

---

what is incremental aggregation ,with example?

2 Answers  

---

What is the use of target designer?

0 Answers  

---

how can we calculate fact table size?

1 Answers  

---

can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,

---

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

4 Answers   Wipro,

---

What is source qualifier transformation?

1 Answers  

---

Which is better performance wise database or file?How?

2 Answers   TCS,

---

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?

5 Answers   Patni,

---

What is surrogate key?

9 Answers  

---