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
- 22791 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
what is the complex transformation you used in informatica
What is target load order?
where to store informatica rejected data?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Partition, what happens if the specified key range is shorter and longer
According to his methodology what all you need before you build a datawarehouse
What is the benefit of session partitioning?
What does cheating measurement mean?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Separate from a database, an information bazaar, and an information stockroom?
Under what condition selecting sorted input in aggregator may fail the session?
How to create a non-reusable instance of reusable transformations?
What is informatica powercenter repository?
what is $$$$?
