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

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers   TCS,

---

my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.

5 Answers   IBM,

---

How do you set a varible in incremental aggregation

1 Answers  

---

tell me 5 session failure in real time how can you solve that in your project?

1 Answers   CSC,

---

Explain the code page compatibility?

1 Answers  

---

What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

8 Answers   TCS,

---

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers  

---

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

3 Answers   Accenture, CSC,

---

how many types of dimensions are available in informatica?

1 Answers  

---

Two different admin users created for repository are ______ and_______

1 Answers  

---

what are challenges that you faced in testing? give solution to it?

1 Answers  

---

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

4 Answers  

---