ALLInterview.com :: Home Page
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   Errors
   Testimonials Refer this Site  Refer This Site to Your Friends  Site Map  Contact Us      
   
 
 Categories >> Software >> Data Warehouse >> Informatica
 
Suggest New Category 
 


   


Question Asked @ Answers Views     Select
How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.    1  88
replace multiple spaces with single space.    3  269
scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS    0  97
case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,    1  204
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.    1  241
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    0  111
How to load query faster,so that It will take less time to load?    0  179
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?    1  261
Can we make worklet inside worklet?    1  336
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?    0  96
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    0  104
what is the difference between repository & Intergration service    1  587
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?    0  375
How to read data from flat file source if the data is in paragraph format?    1  335
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?    3  977
E-Mail New Answers        Answer Selected Questions        Post New informatica Questions
 [1]    2  ... 9   ... 17   ... 25   ... 33   ... 41   ... 49   ... 57   ... 65   ... 73   ... 81   ... 89   ... 97   ... 105   ... 113    Next
 
 
 
 
 
Un-Answered Questions
 
 Question Views   Select
 
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format . 259
explain about unit testing? in real time? 468
what is the hint? how to use it to reduce the query processing in program? 3274
Can we change Dynamic to Static or Persistent cache? If so what happens? 493
How do you use reject loader. 372
How many transformations can be used in mapplets. 183
Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target) 152
How u use pdf file in informatica source? 3257
Parameter and variable differences 289
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ? 561
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping? 170
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE? 507
what is the size of your data warehousing? 419
According to his methodology what all you need before you build a datawarehouse 170
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance 435
E-Mail New Answers        Answer Selected Questions