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
- 12599 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
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the reusable transformations?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What are session parameters ? How do you set them?
What is a stored procedure transformation?
What is the difference between informatics 7x and 8x and what is latest version?
What is meant by lookup transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
what is informatica metadata?
Is stop and abort are same in informatica?
What are the differences between a connected lookup and unconnected lookup?
What is the benefit of partitioning a session?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Explain the mapping variable usage example in informatica
What is data movement mode in Informatica and difference between them?
