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 lac of flat fles in source how to load target at a time?

Answers were Sorted based on User's Feedback



1 lac of flat fles in source how to load target at a time?..

Answer / anoymous

This can be done by File list or File repository. Create
rep.txt file list in that write all the paths of the i lac
flat files.
in session level set the following attributes
source file name indirect
source file directory filelist path address
source file name rep.txt

Is This Answer Correct ?    14 Yes 0 No

1 lac of flat fles in source how to load target at a time?..

Answer / mike

@ above answer
well its source filetype which need to be indirect

Is This Answer Correct ?    2 Yes 0 No

1 lac of flat fles in source how to load target at a time?..

Answer / usha

By using list file concept we can process 1lac files.
list of files should have same struture.
then only we can process all file.another importent thing
we should set source file type as indirect

in session level set the following attributes
source file type indirect
source file directory filelist path address
source file name file_s.lsh

Is This Answer Correct ?    1 Yes 0 No

1 lac of flat fles in source how to load target at a time?..

Answer / manojkumar

I think Source file name should end with .lst extension
like "filename.lst"

And this list file shoud include all 1Lac file names.
Remaining all same as above only.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Informatica Interview Questions

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...

0 Answers  


for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,


what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,


Can you access a repository created in previous version of Informatica?

1 Answers  


how u know when to use a static cache and dynamic cache in lookup transformation.

9 Answers   Accenture,


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  


How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers   TetraSoft,


i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence

1 Answers   IBM,


Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  


I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,


There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

1 Answers   Wipro,


What is informatica? Why do we need it?

0 Answers  


Categories