What is update override?
- 1 Answers
- 6174 Views
- Accenture, I also Faced
- E-Mail Answers
Answer / abhinav
Update Override is an option in Informatica at the session
level. In this, you can manually enter the SQL query to be
used. This query will be issued to the Database when the
session is run, overriding the SQL query generated by that
particular transformation at the mapping level.
| Is This Answer Correct ? | 9 Yes | 0 No |
What are the ETL tools available in DWH?
Enlist some properties of sessions.
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
How to update or delete the rows in a target, which do not have key fields?
What is confirmed fact in dataware housing?
What do you mean by enterprise data warehousing?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the mapings that we use for slowly changing dimension table?
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
How to eliminate 1st and last rows from the source and load the inbetween rows.
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
What is souce qualifier transformation it is active or passive
Teradata 
