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
Differences between version 7.x and 8.x.
What are Dimensional table?
Difference between Target-based loading and constraint-based loading?
Clarify the utilization of aggregator cache record?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Global and Local shortcuts. Advantages.
How does a rank transform differ from aggregator transform functions max and min?
What is the function of look up transformation?
How can repository reports be accessed without sql or other transformations?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How do you remove duplicate records in informatica? And how many ways are there to do it?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How many types of sessions are there in informatica.please explain them?
What is dynamic cache?