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?
- 10 Answers
- 22759 Views
- Wipro, I also Faced
- E-Mail Answers
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
How to generate sequence numbers without using the sequence generator transformation?
What is main use of mapplet?
How do you take back up of repository?
Which transformation is needed while using the Cobol sources as source definitions?
wat are deployement groups in informatica, how it will be used for developers
What is an active transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
Different sorts of metadata that stores in the storage facility?
What is incremental aggregation?
What do you mean incremental aggregation?
Can we create multiple integration service on single repository?
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.
Whats there in global repository
As union transformation gives UNION ALL output, how you will get the UNION output?
Please let me know how to make encryption and decryption with example?
