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

Insert else update option in which situation we will use

4 Answers   HCL,

---

What is the Rankindex in Ranktransformation?

7 Answers  

---

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,

---

In joiner, how to load Master table in Target?

2 Answers  

---

how to sort date field in infomatica?

2 Answers  

---

What do mean by local and global repository?

0 Answers  

---

performance wise which one is better in joiner and lookup transformation

2 Answers  

---

I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,

---

1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.

0 Answers  

---

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,

---

what is the diff b/w union and joiner and lookup?

4 Answers  

---