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

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers   HP,

Why we select the table which has minimum number of records as Master table in joiner?

4 Answers   HG, UST,

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers   Infinite Computer Solutions,

Describe the impact of several join conditions and join order in a joiner transformation?

0 Answers  

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com

0 Answers  




Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

1 Answers   IBM,

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,

What is IQD file?

1 Answers  

difference between informatica 8.6 and 9

3 Answers   Atos Origin, BA Continnum Solutions, Core Logic,

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

1 Answers   Cap Gemini,

Explain the scenario which compels informatica server to reject files?

0 Answers  

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

For more Informatica Interview Questions Click Here
Categories