Answer / polimera

create pass through mapping

src----> sq--->trg

in source qualifier , double click on it and select
properties tab

her select that "add currenttly proccesed file name"

and in target create one port kto store filename.

in session properties select that indirect method

for this you need to create one list file with all the 4
file paths

then it loads every record with its file name.


please guys if u have any queries let me know,

u can send ur queries to my mail id:

polimera.r.reddy@gmail.com

Answer / ramakrishna

double click the source go to properties tab check the
"ADD CURRENT PROCESSED FILE NAME PORT"

Answer / prakash

A small correction of polimera.r.reddy@gmail.com.

'Add Currently Processed Flat File Name Port' option present
at source definition.

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

5 Answers   Informatica,

---

tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

3 Answers   IBM, Patni, TCS,

---

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,

---

What is power center repository?

1 Answers  

---

I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,

---

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

1 Answers   KPIT,

---

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

How can we update a record in the target table without using update strategy?

0 Answers  

---

Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 Answers  

---

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

---

how can we load starting with 11th record of a table from source to target

6 Answers   IBM,

---

Informatica settings are available in which file?

0 Answers   Informatica,

---