What is the method of loading 5 flat files of having same
structure to a single target and which transformations I can
use?

Answer Posted / dragon

I have a query, suppose i have 6 file in 3 different ftp
server with same file structure and i want to load data
using single mappping. In this case how can we use filelist.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Repository user profiles

1373


What is the fact table?

584


What is substr in informatica?

659


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6399


Sequence generator, when you move from develoment to production how will you reset

1403






Design a mapping to load a target table with the following values from the above source?

870


Explain the pipeline partition with real time example?

649


what is the hint? how to use it to reduce the query processing in program?

6287


what is size of u r database?

1844


Explain the shared cache and re-cache?

608


What are the types of caches in lookup? Explain them.

547


What are the settings that you use to configure the joiner transformation?

611


Difference between Data and Index Caches?

649


complex mapping ur project u r invlve can u explain and give real time example give me ?

1836


Define joiner transformation?

589