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.

differences between service based and product based?

0 Answers   Satyam,

---

How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers   Eureka Forbes,

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

4 Answers   Cap Gemini,

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

0 Answers  

---

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

1 Answers   KPIT,

---

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

---

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,

---

Define maping and sessions?

3 Answers  

---

how to calculate the optimum cache size in aggregator transformation?

1 Answers  

---

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

0 Answers   TCS,

---

What is rank transform?

0 Answers  

---

Clarify the utilization of aggregator cache record?

0 Answers  

---