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

What is aggregate cache in aggregator transformation?

865


what is the Default Source Option For Update Strategy Transformation?

1008


What is the need of etl tools?

873


What is workflow? What are the components of workflow manager?

951


What are the main features of Oracle 8i with context to datawarehouse?

1898


server hot-ws270 is connect to Repository B. What does it mean?

2183


What are the advantages of using informatica as an etl tool over teradata?

805


What are the new features of informatica 9.x in developer level?

804


What are the differences between joiner transformation and source qualifier transformation?

915


r u done any partitions in ur project?

1606


How can we use batches?

812


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1831


Explain direct and indirect flat file loading (source file type) - informatica

1109


Explain the scenario which compels informatica server to reject files?

941


Mention few power centre client applications with their basic purpose?

754