Informatica - i have a flat file which i am using as my source , i want to match the records in the flat files wit

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 68 of 302

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 help

Thanks
Nayana

Total Answers and Comments: 6

Last Update: May 26, 2008 Asked by: nayana

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

September 08, 2006 04:54:34

siva sankar

RE: i have a flat file which i am using as my source ,...

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

Is this answer useful? Yes | No

October 18, 2006 08:05:05

phanimv

Member Since: July 2006 Contribution: 41

RE: i have a flat file which i am using as my source ,...

if the two sources are homogenous then u can use lookup transformation otherwise use joiner transformation.As ur question u should use joiner tr. insted of lookup tr. if tre is any prob. send mail phani_mv1@yahoo.co.in

Is this answer useful? Yes | No

January 11, 2007 05:13:08

RE: i have a flat file which i am using as my source ,...

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.

Is this answer useful? Yes | No

February 27, 2007 01:41:21

himanshutiwari

RE: i have a flat file which i am using as my source ,...

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 ....'

Is this answer useful? Yes | No

May 09, 2007 08:50:14

SRIRAM N

RE: i have a flat file which i am using as my source ,...

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

Is this answer useful? Yes | No

May 26, 2008 04:02:15

anupama2000

Member Since: May 2008 Contribution: 13

RE: 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 a

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

Is this answer useful? Yes | No

Go To Top