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 / raja
we use the union transformation,but metadata must be same
then it is possible to join the two hetrogenous tables
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Explain your project of banking domian.
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Explain the scenario which compels informatica server to reject files?
Explain the use of aggregator cache file?
How you prepared reports for OLAP?
Which is the t/r that builts only single cache memory?
What are Dimensional table?
What is meant by lookup transformation?
lookup transformation with screenshots
What is repository manager?
Explain how to import oracle sequence into informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is informatica etl tool?
Slowly changing dimensions, types and where will you use them