I have a scenario with lookup table. in that lookup table have
colomns, but i need to process only 10 colomns out of 50.
Please te me how can we acheive it?

Answer Posted / reddy

i think we can use unconnected look up t/r to acieve this.

Is This Answer Correct ?    0 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is informatica metadata and where is it stored?

581


What is a sorter transformation?

657


if we have a delimiters at unwanted places in a flat file how can we over come those.

1564


What is an aggregator transformation?

613


difference between informatica 8.1.1 and 8.6

3236






How to load data in informatica ?

567


Design a mapping to load a target table with the following values from the above source?

870


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

6360


Explain Dataware house architecture .how data flow from intial to end?

2120


What is Cognos script editor?

3782


What is the use of transformation?

569


What are the tasks that source qualifier perform?

629


where to store informatica rejected data?

672


Mention few advantages of router transformation over filter transformation.

633


Parameter and variable differences

1613