Answer / rakesh

Using FileList concept.
i.e; keep all flat file paths in a text file and mention
this file name in source file name of session. and mention
the source file type as INDIRECT.

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,

---

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers   HP,

---

How to fix the etl bugs..Tell me the process?

1 Answers   IBM,

---

Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 Answers  

---

My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,

---

---

Can informatica load heterogeneous targets from heterogeneous sources?

0 Answers  

---

how to create a sample mapping for dynamic lookup transformation

2 Answers  

---

why u go for dimensions ?

3 Answers   TCS,

---

What is joiner transformation?

0 Answers  

---

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

---

How do you handle two sessions in Informatica

0 Answers   Informatica,

---

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  

---