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

Hi,
I know this is possible but not sure how.. SQ is used for
Homogenius sources. Anyone else please try to get a
positive answer on this one.

Is This Answer Correct ?    3 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

834


What is pmcmd command?

768


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1438


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1789


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

690






What are active transformations.

1291


How to do the error handling of if ur source is flatfiles?

1604


What are different types of transformations available in informatica?

670


Differentiate between router and filter transformation?

695


What do mean by local and global repository?

813


can we override a native sql query within informatica? How do we do it?

744


can you please explain me pre session and post session options?

6624


What is powercenter on grid?

813


What is DR strategy for Informatica project?

806


What are roles and groups and benefits of using them?

656