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

we have table like cust_id,cust_name,cust_loc like this
1.we need to get perticular location,to do this we can use
filter transformatin,that logic is same for relation table
and flat file tabl?

Question Posted / mohanreddy

Answers were Sorted based on User's Feedback



we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do ..

Answer / rahul

You can write the SQL statement for that particular
location in the source qualifier if it is a relational
table.
Use Filter if it is a flat file.

Is This Answer Correct ?    0 Yes 0 No

we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do ..

Answer / sreenu

yes
but if it is a relational table beter to use SQL overried
for performence
for flat files u have to use filter t/r

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Informatica Interview Questions

What is confirmed dimension?

3 Answers  

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,

What are the different ways to implement parallel processing in informatica?

0 Answers  

What is surrogate key?

9 Answers  

How mapping parameter and variable works

1 Answers  

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

0 Answers   Patni,

What are the advantages of informatica?

0 Answers  

What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,

how to delete duplicate records by using filter transfermation?

3 Answers  

what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,

Define joiner transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories