How to delete the data in the target table after loaded.
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 |
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 Answers BirlaSoft, Genpact, L&T, Syntel,
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
What is rank transform?
differences between service based and product based?
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
How you count the number of records available at your source?
What is the query to find nth highest salary? What is the use of cursors?
From where we can start or use pmcmd?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain the mapping variable usage example in informatica
What is facttable granularity?
what is the diff b/w union and joiner and lookup?