Interested to Buy Any Domain ? << Click Here >> for more details...
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 .
- 4 Answers
- 12541 Views
- I also Faced
- E-Mail Answers
Answer Posted / rabi mishra
Hi
as per my knowledge , indirect loading of more than one
source files with same meta data, needs a file repository
concept.
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.
Hope this will satisfy ur Problem.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
How to create or import flat file definition in to the warehouse designer?
What is an expression transformation?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is a surrogate key?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Enlist the various types of transformations.
Define the various join types of joiner transformation?
How to use procedural logic inside infromatica?
Briefly define reusable transformation?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain the scenario which compels informatica server to reject files?
Why do you use Mapping Parameter and mapping variable?
write a query to retrieve the latest records from the table sorted by version(scd)
Explain sessions. Explain how batches are used to combine executions?
