Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

CTS,

2 2560

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

HCL,

1 2800

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

HCL,

4 3841

Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

TCS, Wipro,

4 4460

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

TCS, Wipro,

1026

when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 3876

How to read data from flat file source if the data is in paragraph format?

Wipro,

2 2797

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

Wipro,

1458

what is the difference between repository & Intergration service

1 2834

My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this

2 1919

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

851

Can we make worklet inside worklet?

1 5121

I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 2374

How to load query faster,so that It will take less time to load?

BNP Paribas,

1 2027

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

1004


Post New Informatica Questions






Un-Answered Questions { Informatica }

how to load dimension table and fact table. plz tell me the steps.

1281


How to Create a folder using pmrep command?

161


What is flashback table ? Advance thanks

986


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1137


What is a mapplet/worklet in informatica?

154






What do think which one is the better joiner or look up?

173


What is meant by lookup transformation? Explain the types of lookup transformation?

140


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1097


What is data caches/ index caches?

154


Define mapping and session?

163


What is meant by query override?

174


How to call shell scripts from informatica?

150


What is a shortcut and copy in Informatica and how two are different with each other?

178


What is resilience time?

178


What is session task and command task?

164