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 / anoymous
Not possible to join flat file without transformations
however relational sources can be joined in source qualifier
ex: select * from emp,dept;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define update strategy?
Define mapping and session?
What are the different versions of informatica?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Quickly characterize reusable change?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is the scenario which compels informatica server to reject files?
Explain the shared cache and re-cache?
explain about unit testing? in real time?
Can informatica load heterogeneous targets from heterogeneous sources?
How to join three sources using joiner?
What is Data Caches size?
Clarify the utilization of aggregator cache record?