Answer / vishnu_kr

Hi,

i guess the SQL override is used in the source qualifier trf
to implement joins, filter, sorter etc..

but update override is used in the Target table definition.
u use this option to update Targets that have no primary
key (hence u can't use update strategy) coupled
with 'Update as update' property in the session mappings tab
and 'Treat rows as' property set as 'Update' in the session
Properties tab.

Answer / ram reddy

Update Override it is an option available in TARGET
instance.By defalut Target table is updated based on
Primary key values.To update the Target table on non
primary key values u can generate the default Querey and
override the Querey according to the requiremnet.Suppose
for example u want to update the record in target table
When a column value='AAA' then u can include this condition
in where clause of default Querey.

Coming to SQL override it is an option available in Source
Qualifier and Lookup transafornmation where u can inlude
joins ,filters,Group by and order by.

Answer / raj

u can get this "update override" by double clicking or right
clicking the target .

Answer / vishnu_kr

hi,

sorry for a small mistake in the last answer

u use 'update else insert' property in the session mappings
tab.

Answer / lokendra

You can override the WHERE clause to include non-key
columns by using target override

Answer / praveen kumar pendekanti

In the case of source qualifier when we use sql override
opition we will get query with our alias name and when we
user update transformation override when we enter update
override we will get column names with alias name


In update transformation order by clause is default that is
not in sql over ride(According to my knowledge)

If i am wrong plz correct me to my mail-id.....

Answer / uzval_vee

hai

i guess this question comes under scd's itseems,
becoz in scd type1 we will overwrite the oldvalue with new
value.here we dont have any history

write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

2 Answers   TCS,

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

What are the new features of the server manager in the informatica 5.0?

1 Answers  

what is the process we used in joiner transformation,there is no matching column in sources?

2 Answers  

What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,

How to load only the first and last record of a flat file into the target?

3 Answers   Mind Tree,

Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.

27 Answers  

Mapplets can you use an active transformation in a mapplet,

1 Answers  

hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.

2 Answers  

What are the uses of etl tools?

0 Answers  

what is bridge tables in informatica

1 Answers   CTS,

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

5 Answers   TCS,