Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 6 Answers
- 11103 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / priyank
Except the 10 columns, if any other column is not being
used for any matching/filter condition, then remove the
columns from the look up table and the columns which are
used in the filter condition but are not taken forward in
the target, uncheck the oputput port and keep them as Input
port.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How would you copy the content of one repository to another repository?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How to update source definition?
How many input parameters can exist in an unconnected lookup?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Design a mapping to load the cumulative sum of salaries of employees into target table?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is a snowflake schema?
What are the advantages of using informatica as an etl tool over teradata?
server hot-ws270 is connect to Repository B. What does it mean?
What is the use of code page?
What is a filter transformation and why it is an active one?
