What is the "File Repository" and how can we use that in the
Informatica ? Please give one example of the Process ?
waiting for Reply... Thank you .
Answer Posted / kasi g
in which we create a new file , and stores the source
file absolute paths in that.we create one mapping with one
metadata. in session properties we give the source file
name as of the new file. and make the source load type
as 'indirect'.so as the session runs ,data from all the
files will be loaded with one go.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Different qualification between a related rotate toward the sky and isolates look upward?
How can you define user defied event?
What is deployment group?
How can we use mapping variables in informatica? Where do we use them?
Explain informatica architecture - version 8 / 9
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is the Rank index port in Rank transformation?
What is the use of an aggregator cache file?
What are the new features of informatica 9.x at the developer level?
Define joiner transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is the cumulative sum and moving sum?
Define Pmrep command?