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

can a port in expression transf be given the name DISTINCT

3 Answers  

---

what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,

---

What do mean by local and global repository?

0 Answers  

---

How to display null values on a target & non-null values on a target?

3 Answers  

---

What is the functionality of update strategy?

2 Answers  

---

---

what are the limitation of sorter transformation?

2 Answers   TCS,

---

What is A complex mapping?

3 Answers   TCS,

---

Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.

0 Answers  

---

How to load the source table into flat file target(with columns) in informatica?

4 Answers   Accenture,

---

what are the perameter and variable?

3 Answers   IBM,

---

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,

---

What is workflow? What are the components of workflow manager?

0 Answers  

---