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



Data Warehouse Interview Questions
Questions Answers Views Company eMail

Which is better performance wise database or file?How?

TCS,

2 6633

I am having 10 records in i/p file,and i want to load only one record at a time to the output file.Then how can i do it?

IBM,

2 8719

Can any body give me the clear explanation about how to separate header,trailer and body records in Ab Initio?

TCS, Wipro,

2 18716

from a graph how to select only second record always in scan?

IBM,

3 13970

Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?

1 4106

How u use pdf file in informatica source?

Ericsson, HP, IBM,

2 7221

What is joiner cache?

TCS,

2 6622

What is use of batch file in informatica? How many types of batch file in informatica?

EXL,

2 19846

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 6198

Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x

7 11300

I want to run one page with filter and another page without filter, what is process?

1 5078

Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

1 4038

Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

2206

How can i send first half of the records to one target and Remaining to other target?

TCS,

10 29750

If the records doesnt satisfy the filter condition where will it go?

IBM,

10 16369


Un-Answered Questions { Data Warehouse }

Enlist the functions performed by sas.

1145


Can you explain the advantage of using shortcuts?

1043


what kind of system requirement is needed to run tm1 for a small installation?

5


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1139


rank() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid order by case when opt2.dm_market_flg in ('Y', 'U') then 1 else 2 end, lkp.contact_rank) as rank1, case opt2.contact_type when 'Buyer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, ship_to_flg desc , last_order_dt desc) when 'Decision Maker' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc , last_quote_dt desc , mailability_score desc , source_ranking desc) when 'Influencer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) when 'Payer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) --elu 05/28/2013 else row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) end rank2 row_number() over (partition by opt3.dim_plat_site_id, opt3.dim_site_opt_sid order by rank1,rank2) as "rank", case when "rank"<= opt3.maximum_value then 'Y' else 'N' end as include_flg

1977


i have one file i saved in csv how can i take these file into framework manager

2092


What exactly do you know about the typical data analysis?

1122


Define ds designer?

1289


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3134


if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

1926


What is main difference mapplets and mapping?

1208


If a variable contains letters or special characters, can it be numeric data type?

1223


What is the difference between orabulk and bcp stages?

1042


Name few SAS functions?

1104


How can we update a record in the target table without using update strategy?

1160