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

Differentiate between a database and data warehouse?

656


expain about the tune parameters?

1890


What is an aggregator transformation?

617


what is the size ur source like(file system or database)? how many record daily come u r banking project?

1753


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1760






How you can differentiate between connected lookup and unconnected lookup?

617


How can you validate all mappings in the repository simultaneously?

762


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

631


What is a router transformation?

633


What is an active transformation?

648


Explain pushdown optimization and types in informatica

672


Enlist few areas or real-time situations where informatica is required.

597


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

1859


what is $$$$?

1742


Write the advantages of partitioning a session?

752