i have ten flat files with same structure,if
i want to load it to single target,and mapping needs to
should show only one source.what will be the steps to taken
to achieve it?/
Answer Posted / venkat
Create one parameter file and give all 10 flat files paths
in paramer file and use this parameter file in session
properties giving parameter file path and target should be
indirect than load in to target with single source.
Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What is the way to execute pl/sql script using informatica mapping?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is resilience time?
Performance tuning( what you did in performance tuning)
What is parallel processing in informatica?
How do you update the records with or without using update strategy?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How we can create indexes after completing the loan process?
What is aggregator transformation in informatica?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
can u give example for factless fact table
What is the use of source qualifier?
What is blocking transformation?
Explain dynamic target flat file name generation in informatica
What are the components of workflow manager?