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
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is the need of an ETL tool?
explain about unit testing? in real time?
Explain how many types of dimensions are available in informatica?
What is aggregate cache in aggregator transformation?
Explain transaction control transformation in informatica
Can u generate reports in Informatica?
What do you understand by term role-playing dimension?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
difference between informatica 8.1.1 and 8.6
How can we handle two sessions in informatica?
What is incremental aggregation?
Write the unconnected lookup syntax?
Is there any target staging area in informatica not staging area
How can we update a record in the target table without using update strategy?