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
What is a passive transformation?
What is meant by a domain?
What do you understand by term role-playing dimension?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is primary and backup node?
In informatics server which files are created during the session rums?
How to generate sequence numbers without using the sequence generator transformation?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What are the transformations that are not supported in mapplet?
list out all the transformations which use cache?
What is decode in static cache?
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.
What do you mean incremental aggregation?
How do you load first and last records into target table?
Explain the different lookup methods used in informatica?