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 / sairam
IN CONNECTED LOOKUP TRANSFORMATION OUTPUT PORT YOU PUT IN UNCHECK 40 COLOMNS AND YOU GET RESULT 10 COLOUMNS
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
How can we update a record in the target table without using update strategy?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
While migrating the data from one environment to another environment how would you manage the connections?
How do you load unique records into one target table and duplicate records into a different target table?
What are Dimensional table?
On which transformations you created partitions in your project?
Why filter transformation is an active one?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is the meaning of up gradation of repository?
What are session parameters ? How do you set them?
How identifying bottlenecks in various components of informatica and resolving them?
Separate from an archive server and a powerhouse?
What are the tasks that can be performed using sq?
What are the types of caches in lookup? Explain them.
How to extract sap data using informatica?