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

What is the term PIPELINE in informatica ?

7 Answers   Deloitte,

---

how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

---

what are the difference between Informatica 7.1 and 8.1?

6 Answers  

---

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,

---

What is rank transformation in informatica

0 Answers   Informatica,

---

How do you use reject loader.

0 Answers  

---

what are the perameter and variable?

3 Answers   IBM,

---

why we use stored procedure transformation?

4 Answers   IBM,

---

In which scenario did you used pushdown optimization?

1 Answers  

---

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,

---

Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 Answers  

---