Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete the data in the target table after loaded.
- 3 Answers
- 9437 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / venky
write post sql in target table as truncate table tablename
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / honey
SQ---> Properties tab-->Post SQL
delete from target_tablename
SQL statments(s) executed using the source database
connection, after a pipeline is run
| Is This Answer Correct ? | 6 Yes | 2 No |
we have the property in session truncate option.
| Is This Answer Correct ? | 1 Yes | 10 No |
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
what is data driven?
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
how the informatica server sorts the strings values in rank transformations?
How to prepared lld.can any one tell me detailed explanetion.
What are variable ports and list two situations when they can be used?
Explain scd type 3 through mapping.
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
What are mapping parametres and variables in informatica?
What is lookup transformation?
Teradata 
