hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE
USING SQL T/R ?
Answer Posted / pooja
write sql query in tgt property .. per sql & post sql
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
how many types of dimensions are available in informatica?
how tokens will generate?
What is joiner transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What all join we can perform in LOOKUP transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Why update strategy and union transformations are active?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Briefly describe lookup transformation?
What is status code in informatica?
Explain the etl program with few examples.
What do you mean by blocking transformation?
What is the difference between a connected look up and unconnected lookup?