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


Please Help Members By Posting Answers For Below Questions

Define update strategy?

832


Define mapping and session?

792


What are the different versions of informatica?

958


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1803


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

2361


Quickly characterize reusable change?

916


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1844


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.

893


What is the scenario which compels informatica server to reject files?

841


Explain the shared cache and re-cache?

835


explain about unit testing? in real time?

1920


Can informatica load heterogeneous targets from heterogeneous sources?

948


How to join three sources using joiner?

824


What is Data Caches size?

843


Clarify the utilization of aggregator cache record?

783