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
Separate from a database, an information bazaar, and an information stockroom?
What are the tasks that source qualifier perform?
How do you handle two sessions in Informatica
What is a mapplet/worklet in informatica?
What is update strategy transform?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is option by which we can run all the sessions in a batch simultaneously?
How to create Target definition for flat files?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are mapplets?
How many input parameters can exist in an unconnected lookup?
How can we update a record in the target table without using update strategy?
What is the difference between Active and Passive transformation?
How do you load only null records into target?