How to load the data from a flat file into the target where the source flat file name changes daily?
No Answer is Posted For this Question
Be the First to Post Answer
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
Explain what is informatica metadata and where is it stored?
what is the significance of newlookup port in dynamic look up
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
what is the diff b/w target load plan and cbl?
What you know about transaction control transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Slowly changing dimensions, types and where will you use them
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?