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 / aakansha

It is not possible to join a flat file and relational source
without joiner/lookup. Source qualifier is used for
heterogeneous source...means source belongs to same
database...in the ur case flat file and relational source
not belong to same database so...we cant join it into SQ.

Is This Answer Correct ?    15 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how many types of dimensions are available in informatica?

647


How do you update the records with or without using update strategy?

756


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1163


Describe an informatica powercenter?

714


Explain load alternative records / rows into multiple targets - informatica

807






What is informatica metadata and where is it stored?

669


What is the cumulative sum and moving sum?

865


How do you manage the Parameter files while migrating your data from one environment to another environment?

653


What are the databases that informatica can connect to windows?

677


What is meant by query override?

738


What are the differences between source qualifier and joiner transformation?

682


How to configure mapping in informatica?

773


is it possible to index the data in cache of lkp transformation ?

1624


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1602


What are the popular informatica products?

720