Interested to Buy Any Domain ? << Click Here >> for more details...
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE
USING SQL T/R ?
- 4 Answers
- 11260 Views
- I also Faced
- E-Mail Answers
Answer Posted / shyam
by using dd_delete(2) in UPDATESTRATAGY trnsformation we
can delete rows.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is a dimensional model?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How many transformations can be used in mapplets.
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Make a note of the quantity vaults made in informatica?
What is target load order?
What is the sequence generator transformation in informatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Whats there in global repository
What is the different lookup cache(s)?
Performance tuning in UNIX for informatica mappings?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are some examples of informatica etl programs?
