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 flashback table ? Advance thanks
What are the tasks that source qualifier perform?
How does the aggregator transformation handle null values?
What do you mean by blocking transformation?
What is the session task and command task?
Explain sessions. Explain how batches are used to combine executions?
which one is better performance wise joiner or look up
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Do you find any difficulty while working with flat files as source and target?
What are the advantages of using informatica as an etl tool over teradata?
What are the types of lookup transformation?
What is a stored procedure transformation?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
how we can load rejected record's at run time?(not through bad files)