I have a flat file which i am using as my source , i want to match the records in the flat files with that of my oracle table(using cust_id field). I was advised that i should be using a look up transformation and a filter transformation for this. I am not understanding why i should be using the look up transformation. can anyone please helpThanksNayana

  • Interview Candidate
  • 6
  • 2914

Showing Answers 1 - 6 of 6 Answers

siva sankar

  • Sep 8th, 2006
 

use joiner transformation for match ur flat file records with ur source

  Was this answer useful?  Yes

Guest

  • Jan 11th, 2007
 

Hi,

You are having only one source i. e. flat file as your source right?

You should use lookup transformation here.Looking up this source and load the target by getting required fields

We can lookup flat files you know that right?

After that use filter transformation for restricting null values.

  Was this answer useful?  Yes

himanshutiwari

  • Feb 27th, 2007
 

HI,

There are many ways but the easiest one is, you have to use a joiner, as we can join a flat file and a relation source using joiner. This will match your records.

The filter can be used for filtering the unwanted record, but it's better to implement filter condition level 'where ....'

  Was this answer useful?  Yes

SRIRAM N

  • May 9th, 2007
 

You should use joiner, then you can use filter if you want, or you can enter the filter condition in joiner as well.

  Was this answer useful?  Yes

anupama2000

  • May 26th, 2008
 

the purpose of using lookup transformation is to check the existing data in target table with the column cust_id after satsifying the condition the rows obtained are used according to your business logic using filter transformation

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions