Interested to Buy Any Domain ? << Click Here >> for more details...
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?/
- 5 Answers
- 12124 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / anoymous
Create a file system with extension .txt in that copy all
the 10 flat file paths.
Now at session level
source type : indirect
File directory : File system path
source file name: Name of file system.txt
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
What is the procedure for creating independent data marts from informatica 7.1?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the performance considerations when working with aggregator transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Design a mapping to load a target table with the following values from the above source?
What all join we can perform in LOOKUP transformation?
Can we override a native sql query within informatica?
Explain Dataware house architecture .how data flow from intial to end?
What is sequence generator transformation in informatica?
Can you use flat files in Mapplets.
Define Pmrep command?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain the code page compatibility?
