How to generate or load values in to the target table based on a column value using informatica etl tool.

0 Answers   Informatica,

---

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  

---

How to create Target definition for flat files?

0 Answers   Informatica,

---

How can you define user defied event?

0 Answers  

---

what is curr val use for in sequence generator?

2 Answers   Emphasis,

---

---

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

0 Answers  

---

Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,

---

How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,

---

i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,

---

What are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,

---

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,

---