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 / abhishek upadhyay
Hi All,
Whatever you all have mentioned is true.....that the source
qualifier joins only homogenous tables and as per the
question we can not use a joiner.
But,
If it is a normal join we can do this by using lookup
transformation between those two files.......
In case of full outer or left outer or right outer joins
this will not work..Thanks a lot.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are the types of schemas we have in data warehouse.
Explain about Informatica server process that how it works relates to mapping variables?
What are the main features of Oracle 8i with context to datawarehouse?
Why filter transformation is an active one?
How can we store previous session logs?
whats the logic to load the lower level of granularity of data to fact table.
What is sorter transformation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is the use of transformation?
Explain what are the different versions of informatica?
Write the different tools in the workflow manager?
Where do we use mapping variables in informatica?
What is workflow manager?