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
- 10819 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 to Create a folder using pmrep command?
What is olap (on-line analytical processing?
What are the different clients of powercenter?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How to handle decimal places while importing a flatfile into informatica?
Informatica settings are available in which file?
What is exclusive and normal mode for repository services?
What could be the possible resons of locks by user?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Explain sessions?
What is the sequence generator transformation in informatica?
what is diff b/t sorter t/r and agg have the option sorter property...
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is aggregate cache in aggregator transformation?
