Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
No Answer is Posted For this Question
Be the First to Post Answer
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
Which transformation should u need while using the cobol sources as source defintions?
how to use incremental load?
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
complex mapping ur project u r invlve can u explain and give real time example give me ?
can u give example for factless fact table
is it possible to index the data in cache of lkp transformation ?
what is lookup chache?
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
how to create a sample mapping for dynamic lookup transformation