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


i have two flat files.. containing same type of data
i want to load it to dwh..how many source qualifires i need

Answers were Sorted based on User's Feedback



i have two flat files.. containing same type of data i want to load it to dwh..how many source qual..

Answer / raman m

If the 2 flat files have the same structure,then we can go
for filelist concept in informatica.

only one source qualifier is needed and the source should
be either of the flat files.

Is This Answer Correct ?    32 Yes 0 No

i have two flat files.. containing same type of data i want to load it to dwh..how many source qual..

Answer / gourab

if you have the same file structure.you can configure
indirect loading in the file properties tab of the
session.You will need only one source qualifier
transformation.

Please correct me if i am wrong..

Regards
Gourab

Is This Answer Correct ?    29 Yes 0 No

i have two flat files.. containing same type of data i want to load it to dwh..how many source qual..

Answer / dazzler

bsgr,

what's your problem dude. Why are u asking ppl to get in touch with u. Every now and then I'm finding your request among answers.

Is This Answer Correct ?    1 Yes 1 No

i have two flat files.. containing same type of data i want to load it to dwh..how many source qual..

Answer / arnab

if both the files are same in structure you can concat into
one file using Unix or dos scripts and call the unix and
dos script before execution of the session in ur workflow

This would automate the process and you will not ahve to do
it manually

Is This Answer Correct ?    1 Yes 3 No

i have two flat files.. containing same type of data i want to load it to dwh..how many source qual..

Answer / srikanth

Source Qualifier transformation applies to only for
databases and not for flat files (upto versoin 7.x) but i
have no idea on later versions.

It just acts like a label and we cant configuare or use any
of the properties in source qualifier if the source is flat
file.

Is This Answer Correct ?    0 Yes 4 No

i have two flat files.. containing same type of data i want to load it to dwh..how many source qual..

Answer / naveen

If u have same structure then u can use union transformation

Is This Answer Correct ?    2 Yes 8 No

i have two flat files.. containing same type of data i want to load it to dwh..how many source qual..

Answer / bsgsr

hi raman gud ans,
anyways i am srinvas here. my mail id is
bsrinivas1213@gmail.com wanna be in touch with you. well
its ur wish now

Is This Answer Correct ?    1 Yes 30 No

Post New Answer

More Informatica Interview Questions

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  


how can u load the data in time dimension?

3 Answers  


What is surrogate key?

9 Answers  


what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,


What is the use of an aggregator cache file?

0 Answers  


why we r using presql&postsql in source qualifier?

1 Answers   HP,


Under what conditions selecting sorted input in aggregator will still not boost session performance?

0 Answers  


there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,


i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

4 Answers   Magna Infotech,


Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?

1 Answers  


Hi experts, can anyone tell how much we use plsql in real time

3 Answers  


wt is inline view? when and why we Use ?mail to rayallarv@gmail.com

2 Answers  


Categories