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 a passive transformation?

642


What is meant by a domain?

630


What do you understand by term role-playing dimension?

576


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1658


What is primary and backup node?

700






In informatics server which files are created during the session rums?

639


How to generate sequence numbers without using the sequence generator transformation?

649


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

1583


What are the transformations that are not supported in mapplet?

600


list out all the transformations which use cache?

691


What is decode in static cache?

596


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1765


What do you mean incremental aggregation?

623


How do you load first and last records into target table?

666


Explain the different lookup methods used in informatica?

587