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
Enlist the advantages of informatica.
Differentiate between reusable transformation and mapplet.
What are the guidelines to be followed while using union transformation?
what is INFORMATICA TESTING process
Have you worked with/created Parameter file
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Differentiate between a repository server and a powerhouse?
Which version configuration tool used in ur project?
What is the different lookup cache(s)?
What is joiner transformation?
What is substr in informatica?
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
Do you find any difficulty while working with flat files as source and target?
How to do unit testing in informatica?
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.