Answer Posted / sai suresh
Connected lookup is participats in Mapping level and it
will takes multipul inputs and provides multipul outputs.\
Unconnected lookup is does't participats in Mapping level
and it will takes multipul inputs and provied single output
only
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
According to his methodology what all you need before you build a datawarehouse
What is a code page?
What is sorter transformation?
Differentiate between reusable transformation and mapplet.
How can a transformation be made reusable?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How do you take back up of repository?
What is parallel processing in informatica?
what is size of u r database?
What are the uses of etl tools?
how many types of dimensions are available in informatica?
How might one distinguish in the case of mapping is right or not without associating session?
What is informatica?
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