Interested to Buy Any Domain ? << Click Here >> for more details...
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
9 21159i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
5 9687how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
TCS,
3 7426when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
1 5835when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
1 4697In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
6 9098my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
5 8944my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
TCS,
5 8490Post New Informatica Questions
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How do you set a varible in incremental aggregation
what are the Methods For Creating Reusable Transformations?
Tell me about MD5 functions in informatica
Performance tuning( what you did in performance tuning)
Why union transformation is an active transformation?
which one is better performance wise joiner or look up
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is the command used to run a batch?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is intricate mapping?
What is flashback table ? Advance thanks
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
What is a predefined event?
