why sequence generator should not directly connected to
joiner transformation ?

Answer Posted / srinu

Mainly sequence generator is used to generate an unique id
dynamically.
We can not join this number against any column in other
tables...
So.. we can not connect sequence generator with joiner.

and also,

Main reason is joiner is a Active transformation.Means it
can alter the number of rows.
So, if u connect sequence generator with joiner the outcome
sequence will not be proper.

Any Queries or Corrections
'srinu.srinuvas@gmail.com'

Is This Answer Correct ?    27 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How union transformation is used?

785


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1830


is it possible to index the data in cache of lkp transformation ?

1733


How will the document be delivered to me?

824


How to load the data from a flat file into the target where the source flat file name changes daily?

808


What is informatica metadata and where is it stored?

772


What are the guidelines to be followed while using union transformation?

878


What do you understand by SOA of Informatica?

757


What are the main features of Oracle 8i with context to datawarehouse?

1876


What is the benefit of partitioning a session?

883


what are 3 tech challenges/ common issues you face?

2112


How would you join a node to the already existing domain?

912


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

1738


What is fact table? Explain the different kinds of facts.

801


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1803