hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?

hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE
USING SQL T/R ?

Question Posted / srinivas.medagum

4 Answers
11259 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?..

Answer / pooja

write sql query in tgt property .. per sql & post sql

Is This Answer Correct ?

5 Yes

1 No

hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?..

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

hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?..

Answer / suresh

we can do through update staytgy tr we can delete the row's

Is This Answer Correct ?

3 Yes

2 No

hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?..

Answer / shyam

by using dd_delete(2) in UPDATESTRATAGY trnsformation we
can delete rows.

Is This Answer Correct ?

3 Yes

2 No

Post New Answer

More Informatica Interview Questions

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers

Why the UNION TRANSFERMATION is an Active TRANSFERMATION

6 Answers Emphasis,

explain abt ur project architecture?

0 Answers Anthem, DELL, IBM, TCS, Wipro,

tell me the informatica architecture

1 Answers Banca Sella, Wipro,

Can any one explain or sujjest some sites for scd mappings.Thank you

1 Answers Wipro,

How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers TCS,

Can you create a flatfile target

3 Answers ABC,

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?

2 Answers

how we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers iGate,

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers TCS,

I need an oracle query for convert Char to Integer?. Can any one help me how to do this?

3 Answers

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers TCS,

For more Informatica Interview Questions Click Here