Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

There are 4 source files which contains same metadata create target that should display the file name along with record
please send answer with mapping

Question Posted / kunkala.ramakrishna

Answers were Sorted based on User's Feedback



There are 4 source files which contains same metadata create target that should display the file nam..

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

Is This Answer Correct ?    7 Yes 0 No

There are 4 source files which contains same metadata create target that should display the file nam..

Answer / ramakrishna

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

Is This Answer Correct ?    2 Yes 0 No

There are 4 source files which contains same metadata create target that should display the file nam..

Answer / prakash

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

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,

source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

2 Answers   Wipro,

What are the main issues while working with flat files as source and as targets ?

0 Answers   Informatica,

What are the two modes of datamovement in informatica sever?

2 Answers  

Please let me know how to make Data masking in informatica..

0 Answers  

What is mapplet and a reusable transformation?

2 Answers  

Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.

7 Answers   Cognizant, Wipro,

what is lookup chache?

1 Answers   Patni,

Difference between Data and Index Caches?

0 Answers   Informatica,

After we make a folder shared can it be reversed?Why?

2 Answers   Accenture,

how to identify new and old values in source qualifier or any other transformations using informatica

2 Answers  

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,

For more Informatica Interview Questions Click Here
Categories