When will you use SQL override in a lookup transformation?
Answer / vanita
For filtering the data in lookup table using where clause, or joing multiple tables to select data or to change the default order by clause with your own order by clause
| Is This Answer Correct ? | 10 Yes | 0 No |
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
How do you join more than 3 flat files in informatica?
can we load the data with out a primary key of a table? what is target plan?
what is diff b/t sorter t/r and agg have the option sorter property...
without matching columns in two tables. how can you join
In target table how to display the system time
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
can we generate reports in informatica ? How?
If we set dd_insert in mapping and Delete in session properties what will happen.?
daily how much amount of data send to production?
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
How we can use union transformation?