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
- 11616 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pooja
write sql query in tgt property .. per sql & post sql
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / ankit kansal
The Problem asked about deleting rows using SQL T/R...
So write a sql query like
Delete from table name where col_name = ?input_port?
This is how u will be able to delete a particular row using SQL trans..
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / suresh
we can do through update staytgy tr we can delete the row's
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / shyam
by using dd_delete(2) in UPDATESTRATAGY trnsformation we
can delete rows.
| Is This Answer Correct ? | 3 Yes | 2 No |
What is the use of target designer?
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
Can we use the mapping parameters or variables created in one mapping into another mapping?
i have two source data there is no pk,fk how to join the two sources
what is the drillup & drill down?and use of the drill up and drill down?
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 Answers Accenture, Gcs, TCS,
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
What r the type of indexes u generally used in informatica?
What is the use of transformation?
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
Teradata 
