Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

delete data from staging table as it loads to target table.here is the case
we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

Question Posted / iumair85

Answers were Sorted based on User's Feedback



delete data from staging table as it loads to target table.here is the case we are getting data fro..

Answer / aparna

once the session loads the data to target ,truncate the staging table .So everytime we load is complete ,staging table will be empty .
In POST-SQL (Target ) : truncate the staging table .

Is This Answer Correct ?    3 Yes 0 No

delete data from staging table as it loads to target table.here is the case we are getting data fro..

Answer / ram

Hi,

for identification add a port like source_id in the stage table.

create 3 session instances to load data from 3 sources.

write pre sql in each session instance to delete the
records from stage table.

delete from <stage_table>
where id in (select id from target table)
and source_id=<identifiaction_value>;

please let me know the if you have any questions.
bhupalreddy200@gmail.com

thanks
ram

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More Informatica Interview Questions

What are the new features of the server manager in the informatica 5.0?

1 Answers  

which quality process u can approach in ur project

1 Answers   CTS,

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,

how do u use sequence created in oracle in informatica? Explain with an simple example

6 Answers   CTS,

In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

5 Answers   iNautix,

Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

11 Answers   IBM,

Explain the flow of data in Iinformatica?

1 Answers  

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,

can you use flat file for repository?why?

2 Answers   TCS,

what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,

How might one distinguish in the case of mapping is right or not without associating session?

0 Answers  

For more Informatica Interview Questions Click Here
Categories