1 lac of flat fles in source how to load target at a time?
Answer Posted / 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 |
Post New Answer View All Answers
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
what are factless facts? And in which scenario will you use such kinds of fact tables.
Is there any target staging area in informatica not staging area
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
When do you use sql override in a lookup transformation?
What are the different components of powercenter?
Which is the t/r that builts only single cache memory?
Scheduling properties,whats the default (sequential)
What is DR strategy for Informatica project?
What is the use of transformation?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Describe the impact of several join conditions and join order in a joiner transformation?
update strategy transformation in informatica
What is a repository manager?