Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 26179 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / mallikarjun
Hi Ajith,
It is Possible to Join data from a flat file and a relation
source, this can be done with the help of a joiner
transformation where you have to map one input port to the
relation data column and other to the flat file coumn and
give the joiner condition.. Hope this will help you or drop
a mail...
Thanks & Regards,
Mallikarjun
| Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
tell me the rules and responsblites in our project(my project is development)
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
can u any challenge your project?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How to use pmcmd utility command?
Mention some types of transformation?
Explain pmcmd command usage in informatica
Explain sessions. Explain how batches are used to combine executions?
Which are the different editions of informatica powercenter that are available?
What is the different lookup cache(s)?
What is mapping debugger?
Which version configuration tool used in ur project?
What is the difference between a connected look up and unconnected lookup?
