First lets see how to do indirect file loading.
0)import a flat file and create a mapping to load the flat file data to target.The source you are seeing here below is a flat file.
1)In session you need to set the path of the directory(in fig below see 'source file directory'); which contains a file(in fig below see 'source file name'); having paths to the files which you want to load to target.
With in the text file here it is Path.txt.You need to set the path of the file which you want to load as follows,
one more thing don't forget set the source file type as indirect in Edit Task of session.
;-(
ReplyDeleteThis is a great read for anyone interested in the topic. The explanations are clear and practical.ba analyst course online
ReplyDeleteExcellent content! A MongoDB online course is a great option for students and IT professionals who want to learn database queries, indexing, and performance optimization at their own pace.mongodb training online
ReplyDeleteI enjoyed reading this blog because the content is clear and informative. Keep sharing more articles like this.ab initio online training
ReplyDelete