Answer Posted / rkumar.etl
Informatica has concept of license as well as no. of cpu's
registered to the Repository...They programmed the informatica
software in such a way that without registering repository
to machine you can not proceed informatica designer or
workflow designer or other..
In short it is communication channel to read different
source from different box as well as same box.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to load last n records of file into target table - informatica
What are the different options available for update strategy?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is the function of look up transformation?
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
What are the features of complex mapping?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are the new features of informatica 9.x developer?
On which transformations you created partitions in your project?
Why update strategy and union transformations are active?
Write the unconnected lookup syntax and how to return more than one column.
Explain about Informatica server process that how it works relates to mapping variables?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How do you migrate data from one environment to another?