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
- 22760 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / rahul
no its not possible.
sql trans is used to connect hetro src but when you drag
flat file n connect to Sq t/r , all properties expect
tracing level evey thing will be disable.
SO WE CANT JOIN
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How does a sorter cache works?
How we can create indexes after completing the load process?
What are the components of the workflow manager?
What is decode in informatica?
How are the sources and targets definitions imported in informatica designer?
What is the status code in stored procedure transformation?
What is the fact table?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
scenario where i can use only concurrent execution of workflow.
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Target increases every day even though no new record was inserted
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Mention a few design and development best practices for informatica?
If informatica has its scheduler why using third party scheduler?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
