how do u use sequence created in oracle in informatica?
Explain with an simple example

Answer Posted / kishore

Using SQL transformation we can call the sequence in
informatica.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to generate sequence numbers using expression transformation?

828


HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1900


How to load the data from people soft hrm to people soft erm using informatica?

767


Please let me know how to make Data masking in informatica..

1462


4 yrs etl devloper roles and responsibilities?any body give solutions

1841


What is a snowflake schema?

750


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2312


What are the popular informatica products?

797


What is the sql query overwrite in source qualifier in informatica

816


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1237


what is the -ve test case in your project.

2100


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1395


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

1780


What is union transformation?

741


What is target designer and target load order?

842