How to join a Flat and Relational Source without using (Joiner,
Update and Lookup ) transformations... is it possible? if yes i
would like to know how?
Answer Posted / kishore
We can use union all Transforamtion .if the struture is
same....
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What can we do to improve the performance of informatica aggregator transformation?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the tasks that can be performed using sq?
What do you mean by worklet?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are the components of Informatica? And what is the purpose of each?
What is informatica metadata and where is it stored?
lookup transformation with screenshots
What is the difference between STOP and ABORT options in Workflow Monitor?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is the Rank index port in Rank transformation?
Is stop and abort are same in informatica?