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

How to delete the (flat file) data in the target table after
loaded.

Question Posted / chandumba2005

Answers were Sorted based on User's Feedback



How to delete the (flat file) data in the target table after loaded...

Answer / vaishali bisht

whenever we load data in flat file it automatically override the old data.

Is This Answer Correct ?    0 Yes 0 No

How to delete the (flat file) data in the target table after loaded...

Answer / james

whatever data u want to delete from target table,simply go
with truncate option.

Is This Answer Correct ?    1 Yes 14 No

Post New Answer

More Informatica Interview Questions

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers  

Explain scd type 3 through mapping.

0 Answers  

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?

1 Answers   Franklin Templeton,

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers   IBM,

In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 Answers  

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

How many number of sessions can one group in batches?

0 Answers  

Enlist the tasks for which source qualifier transformation is used.

0 Answers  

What is the Difference between SetVariable and setmaxvariable in informatica?

1 Answers  

How to import oracle sequence into Informatica?

3 Answers   Satyam,

For more Informatica Interview Questions Click Here
Categories