what is diff between IN and EXIT commands
Answer / kamesh
IN: Where they r 2 tables dept and emp the records which r
matched records present in both the table will displayed.
EXIT:the all records are displayed including the records
which are matched.
|Is This Answer Correct ?||6 Yes||0 No|
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
what is update strategy transformation ?
complex mapping ur project u r invlve can u explain and give real time example give me ?
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
How many ways a relational source definition can be updated and what are they?
How will you check the bottle necks in informatica? From where do you start checking?
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
how to create user defined function (udf) in informatica
which one is better either active or passive transformation in informatica
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Without source how to insert record to target?
Can we update the data in flat file using update strategy?