How to import oracle sequence into Informatica?
Answers were Sorted based on User's Feedback
Answer / dr.jornalist
with the help of Stored procedures as well as SQL Override
| Is This Answer Correct ? | 15 Yes | 2 No |
Answer / abhishek
yes first answer is right but through unconnectet lookup
also we can import sequence into informatica
| Is This Answer Correct ? | 5 Yes | 3 No |
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
how many ways can we implement SCD2?
In update strategy target table or flat file which gives more performance ? why?
guys which is the best institute in banglore to learn informatica??
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
what are the differences between powercenter 8.1 and powercenter 8.5?
How are parameters defined in informatica?
how to run the batch using pmcmd command
Define mapplet?
two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
How to load a Dimension ? and how to load a fact table?